Formula Help

[simpson300781]

Hi,

I have a column of data that contains ticks and crosses (P and O values using Windings 2 font). What I want to do is a count of how many cells in the column contact ticks and how many contain crosses. Can someone help with the formula?

 

[Special-K99]

Use COUNTIF using the values P and O.

 

[igold]

How about this. Assuming your column of data is A1:A15:

="There are "&COUNTIF(A1:A15,"P")&" Ticks and "&COUNTIF(A1:A15,"O")&" Crosses"