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.
|