Sumproduct Question

[carl]

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.

[Domenic]

Try...

=SUMPRODUCT(--(D3:D5="OrderO");--(E3:E5="BOX017");--(F3:F5="Directed");--
(G3:G5=226);I3:I5)

Hope this helps!

In article <[email protected]>,
carl <[email protected]> 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.