multiple counts

[pimar]

Hi all.

I need help on a (basic ?) problem I'm not able to solve with the basic functions of excel
I need to count rows in a worksheet where "col A = "a value"" AND "col B = "another value", and then sum the values of col. "C" I was supposed to use COUNTIF but I think it doesn't help

To make clear, if this is my spreadsheet,

Col A Col B Col C

Row1 blocked Y 5
Row2 blocked 8
Row3 blocked Y 8
Row4 blocked 4
Row5 blocked Y 3
Row6 blocked 2
Row7 blocked 4
Row8 working Y 4
Row9 working 2
Row10 working Y 9


then I want to know
1) how many rows where col A = blocked and Col B=Y (result = 3)
2) the total of values in Col 5 for rows that meet the criteria 1 (result = 16)


Any idea?
thanks in advance
*pimar

[Domenic]

1) how many rows where col A = blocked and Col B=Y (result = 3)

=SUMPRODUCT(--(A1:A10="blocked"),--(B1:B10="Y"))

2) the total of values in Col 5 for rows that meet the criteria 1 (result = 16)

=SUMPRODUCT(--(A1:A10="blocked"),--(B1:B10="Y"),C1:C10)

Hope this helps!

[pimar]

Yes it really helped -
thanks a lot
*pimar