COUNTIF

[Picab73]

Hi,

I am using tge COUNTIF function to count cells in a range with a 'tick' symbol. I would like to show the result as  the cells counted is % of total cells in the range. Could someone please assist with the relevant syntax?

Thankyou 

[#2 · Accepted solution]

@Picab73 

If the range were named "tick?" and the symbol is a "ü" then

= COUNTIF(tick?, "ü") / ROWS(tick?)

provides a percentage given the correct cell format.

[#3]

Many thanks Peter, this worked well! 🙂

[#4]

@Picab73 

To ignore which exact character is used for ticks, it could be

=1 - COUNTBLANK(tick?) / ROWS( tick?)

or

=ROWS( TOCOL(tick?,1) ) / ROWS( tick? )

assuming other cells are blank.