IF totals...

[mccdaddy]

Hi. My problem seems simple enough but I'm drawing a blank.

I have a column of text and I need a formula at the base of the column to tell me how often a certain word appears. I start with IF(c7:c50,"CHECK", but I'm stuck here. How can I tell the IF function to total the number of times CHECK appears in c7:c50?

Thanks.

mccd

 

[Andrew Poulsom]

It's:

=COUNTIF(C7:C50,"CHECK")

 

[mccdaddy]

Andrew, thank you so much for your prompt reply. One small problem, though; the words CHECK are followed by a check number and that appears to be impeding the function. Is there a way to have it find CHECK among the other text in the cells?

Thanks again.

mccd

 

[Andrew Poulsom]

Andrew, thank you so much for your prompt reply. One small problem, though; the words CHECK are followed by a check number and that appears to be impeding the function. Is there a way to have it find CHECK among the other text in the cells?

Thanks again.

mccd

That would be:

=COUNTIF(C7:C50,"CHECK*")

 

[mccdaddy]

That did it. I knew it was something simple.

Thank you very much for helping my old, tired brain .

mccd