Forum Discussion
Solved
COUNTIF
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
If the range were named "tick?" and the symbol is a "ü" then
= COUNTIF(tick?, "ü") / ROWS(tick?)provides a percentage given the correct cell format.
If the range were named "tick?" and the symbol is a "ü" then
= COUNTIF(tick?, "ü") / ROWS(tick?)provides a percentage given the correct cell format.
- Many thanks Peter, this worked well! 🙂
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.
