Countif

[Guest]

Hi,
I want to be able to count say "dog" if listed in one column if a "tick" or
yes/no value is entered into a second column in the same row position. i.e.
if the customer is "a" and we met delivery, so "yes" on the same line, count
1.

Thanks,
Sean.

 

[JE McGimpsey]

One way:

=SUMPRODUCT(--(A1:A1000="a"),--(B1:B1000="yes"))

See http://www.mcgimpsey.com/excel/doubleneg.html for an explanation of
how it works.

 

[Peo Sjoblom]

=SUMPRODUCT(--(A2:A100="dog"),--(B2:B100="yes"))

Replace the hardcoded values with cells where you put the criteria

Regards,

Peo Sjoblom