View Single Post
 
Old 04-27-2011, 06:09 AM
apolloman apolloman is offline Windows XP Office 2007
Novice
 
Join Date: Apr 2011
Posts: 16
apolloman is on a distinguished road
Default Product and Sum on 2 rows

I have a worksheet where I am computing daily totals for various workers over a period of time. I have a row(1) with hours worked for a day and the hourly rate underneath row(2). Each day is a separate column, and the hours and the rates are subject to change for any given day. There are many columns. I would like to multiply the hours in row(1) by the rate in row(2), and sum these products across columns A-Z. Also, I would like for it not to fail if there is a blank in one of the columns being considered. Thanks for your help.
Reply With Quote