Ok, I am totally confussed. I am trying to do the same thing. I have a
column of dates, and another column of {High, Medium, Low, Critical}. I am
trying to use SUMPRODUCT to count the number of rows that have Critical on
9/17/2008. Even when I try this:

=SUMPRODUCT(B1:B12="Critical")

I get 0, and there should be 4. So no way can I get this to work:

=SUMPRODUCT((A1:A12="9/17/2008")*(B1:B12="Critical"))

What am I messing up??????

Thanks,
JR


"Pete_UK" wrote:

You can do it like this:

=SUMPRODUCT((I13:I36="v")*(H13:H36="in")*(G13:G36) )

Hope this helps.

Pete

On Sep 18, 10:18 pm, Christy
wrote:
This is what I have:
Col G Col H Col I
15 in v
20 ot v
30 in n
This is what I need to do:
When I13:I36 = v AND H13:H36 = in, THEN add G13:G36
Thanks for your help
Christy