Formula

[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

 

[Dave Peterson]

=sumproduct(--(a1:a100="Ray's Text Here"),--(b1:b100="Yes"))

is one way.

 

[Frank Kabel]

Hi Ray
try
=SUMPRODUCT((A1:A100="your text")*(B1:B100="Yes"))

 

[Merlin]

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