Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-27-2011, 06:09 AM
apolloman apolloman is offline Product and Sum on 2 rows Windows XP Product and Sum on 2 rows Office 2007
Novice
Product and Sum on 2 rows
 
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
 

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft