| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
You have saved my life! Thanks!!!!
"Dave Peterson" wrote: How about: =SUMPRODUCT((C1:C4="V4P")*(E1:E4={"xyz","v4p"})*(G 1:G4)) JN wrote: Wonderful! Thanks so much for helping! Could I bother you for help one more time? Col C Col E Col G VA1 XYZ 1 V4P V4P 2 V4P LNS 3 VA2 VA2 7 I am looking for Excel to look at Col C and Col E and, if the criteria is correct, get totals from Col G. I used SUMPRODUCT((C1:C4="V4P")*(E1:E4="???"),(G1:G4)) where ??? criteria is V4P or LNS. This will work for each (V4P or LNS) but I need it to look at both. The sum would 5 in the above example. "Domenic" wrote: Try... =SUMPRODUCT(--(A1:A4="12/1/2004"+0),--(A1:A4<="12/31/2004"+0),B1:B4) or =SUMPRODUCT(--(A1:A4=C1),--(A1:A4<=D1),B1:B4) ....where C1 contains the start date, and D1 contains the end date. Hope this helps! In article , "JN" wrote: I need to calculate a sum using 2 different date ranges...example Col A Col B 11/29/04 500 11/30/04 2 12/01/04 600 12/02/04 300 I cannot get SUMPRODUCT to work as it will only calc <=11/30/04 or <=12/02/04 but not both. The sum I am looking for would be Nov04=502 and Dec04=900. Does this make sense or is it hopeless? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| Suddenly cannot calculate functions or formulas in Excel | Excel Worksheet Functions | |||
| How do I save a copy of an excel file without the formulas? | Excel Worksheet Functions | |||
| IF/AND formulas within excel | Excel Discussion (Misc queries) | |||
| Problems with Excel formulas when 2002 upgraded to XP | Excel Worksheet Functions | |||
Hybrid Mode
