LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 70
Default SumProduct function

I have 6 columns, which looks like this, I want the sum of all the Ideal time
and Achieved time for A01, A02 and A03 respectively

ID Ideal time achieved time Ideal time Achieved time IDeal time
achieved time
A01 45 50 35 30
30 50
A02 50 35 37 33
25 41
A03 35 25 40 35
60 55

Thanks in Advance!!
Vicky

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sumproduct function / VB user defined function aw Excel Discussion (Misc queries) 3 September 23rd 08 09:05 AM
Is SUMPRODUCT the right function to use? Twishlist Excel Worksheet Functions 4 July 24th 07 02:32 AM
use of sumproduct function R..VENKATARAMAN Excel Worksheet Functions 4 January 23rd 06 02:33 AM
SUMIF Function Inside SUMPRODUCT Function Abdul Waheed Excel Worksheet Functions 17 September 19th 05 04:24 PM
sumproduct function bobf Excel Discussion (Misc queries) 1 March 2nd 05 03:12 PM


All times are GMT +1. The time now is 08:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"