Count with two critera

I have two columns that I want to count based on certain criteria.


cells C1:C8 have values of A, B or C

cells D1:D8 has either a 1 or 0

I want to get the total number of A's in the list that also have a 0 in column D

A 0
B 1
C 0
A 0
A 1
B 1

If I counted all of the A's with 0 the result would be 2

Thanks

Hi there,

Try this formula in the relevant cell:

=SUMPRODUCT((C1:C8="A")*(D1:D8=0))

HTH

Robert