how to count if one column has email and another column has yes

  • Thread starter nested functions
  • Start date
N

nested functions

In one column, i have "email" and in another column i have "yes", "no". I
want to count how many have done email, that is yes and how many have not
done email that is no.

please help me in using the appropriate function,,,,
 
B

Bondi

nested said:
In one column, i have "email" and in another column i have "yes", "no". I
want to count how many have done email, that is yes and how many have not
done email that is no.

please help me in using the appropriate function,,,,
Click to expand...

Hi,

One way to count all the instances of "email" and "yes" is to use:
(Asuming your data is in A1:B10)

=SUMPRODUCT(--(A1:A10="email"),--(B1:B10="yes"))

and "email" and "no"

=SUMPRODUCT(--(A1:A10="email"),--(B1:B10="no"))

If there is "email" in all the rows in column A and you just want to
count "yes" and "no" in column B then maybe you can use:

For "yes" count:
=COUNTIF(B1:B10,"=yes")

For "no" count:
=COUNTIF(B1:B10,"=no")
 
Top