Formula

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

Hello,

Hoping someone can help.

I am trying to count the number of times a particular
text occurs in column B (such as a "Yes") if column A is
equal to a particular text.

Any help would be much appreciated

Thanks

Ray
 
I've always done it with separate "count" columns, ie =IF
(A1="Yes",1,0), then add up the total of the count
column. I don't know if this is the most efficient, but
it works for me. If you think the count column is ugly,
then hide it!
Merlin
 
Back
Top