Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct Question
My data table is like so:
Date Type ID Status GiveUp Name Count 20060314 Order BOX017 226 Q0 2 20060314 OrderO BOX017 Directed 226 Q0 3 20060314 OrderO BOX017 226 Q0 4 I use this formula: =SUMPRODUCT(--(D3:D5="Order");--(E3:E5="BOX017");--(G3:G5=226);--(I3:I5)) I would like to add the condition: If D3:D5="OrderO" and E3:E5="BOX017" and F3:F5="Directed" and G3:G5=226. Not sure how to do this - do I need to use an OR operator ? The result should be: Date Count 20060314 5 Thank you in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct Question
Try...
=SUMPRODUCT(--(D3:D5="OrderO");--(E3:E5="BOX017");--(F3:F5="Directed");-- (G3:G5=226);I3:I5) Hope this helps! In article , carl wrote: My data table is like so: Date Type ID Status GiveUp Name Count 20060314 Order BOX017 226 Q0 2 20060314 OrderO BOX017 Directed 226 Q0 3 20060314 OrderO BOX017 226 Q0 4 I use this formula: =SUMPRODUCT(--(D3:D5="Order");--(E3:E5="BOX017");--(G3:G5=226);--(I3:I5)) I would like to add the condition: If D3:D5="OrderO" and E3:E5="BOX017" and F3:F5="Directed" and G3:G5=226. Not sure how to do this - do I need to use an OR operator ? The result should be: Date Count 20060314 5 Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct Question | Excel Discussion (Misc queries) | |||
SUMPRODUCT Question | Excel Worksheet Functions | |||
SUMPRODUCT question | Excel Worksheet Functions | |||
another sumproduct question | Excel Worksheet Functions | |||
SUMPRODUCT Question... | Excel Discussion (Misc queries) |