SOLVED

# COUNTIF

Copper Contributor

# 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

3 Replies
best response confirmed by Picab73 (Copper Contributor)
Solution

# Re: COUNTIF

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

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

provides a percentage given the correct cell format.

# Re: COUNTIF

Many thanks Peter, this worked well! 🙂

# Re: COUNTIF

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.

1 best response

Accepted Solutions
best response confirmed by Picab73 (Copper Contributor)
Solution

# Re: COUNTIF

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

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

provides a percentage given the correct cell format.