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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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