Countif
 

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.

Countif
 

One way:

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

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

In article ,
SeanHooke wrote:

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.

Countif
 

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

Replace the hardcoded values with cells where you put the criteria

Regards,

Peo Sjoblom


"SeanHooke" wrote in message
...
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.