Product and Sum on 2 rows

apolloman · #1 04-27-2011, 06:09 AM

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.

Colin Legg · #2 04-27-2011, 06:33 AM

Welcome to the forum.

You can do this with SUMPRODUCT().

Code:

=SUMPRODUCT(A1:Z1,A2:Z2)

apolloman · #3 04-27-2011, 07:14 AM

Thanks Colin. That does it.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Odd behaviour of table - keep rows together	Stephan Lindner	Word Tables	1	09-10-2011 05:31 AM
How to remove blank rows from a specified range?	Learner7	Excel	1	04-19-2011 02:45 AM
Rows to Columns	kyakobi	Excel	5	12-07-2010 03:12 PM
Average of many rows	speedycorn1	Excel	1	10-30-2010 07:54 PM
How do I turn the top 2 rows into a header	GR8Fandini	Excel	1	02-06-2010 12:58 PM