SOLVED

COUNTIF

Copper Contributor

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

@Picab73 

image.png

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! :)

@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.

1 best response

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

@Picab73 

image.png

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

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

provides a percentage given the correct cell format.

View solution in original post