G
Guest
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(--(D35="Order");--(E3:E5="BOX017");--(G3:G5=226);--(I3:I5))
I would like to add the condition: If D35="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.
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(--(D35="Order");--(E3:E5="BOX017");--(G3:G5=226);--(I3:I5))
I would like to add the condition: If D35="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.