Mar 12 2021 01:38 PM
Trying to get a percentage of a text from a column... Tried COUNTIF(B2:600,"B")/COUNTA(B2:B600), but it's not accurate.
Mar 12 2021 02:04 PM
That's percentage of cells with values as letter B. What do you mean under "not accurate" ?
Mar 12 2021 02:24 PM
Mar 12 2021 02:34 PM
What means not correct? That's 78.5999999% instead of 78.6% or that's 10% instead of 90% ?
Why don't you provide some sample like
Mar 12 2021 02:47 PM
Mar 12 2021 03:08 PM
SolutionMar 13 2021 06:44 AM
Mar 14 2021 04:09 PM
Mar 14 2021 05:34 PM
Mar 15 2021 08:09 AM
Mar 15 2021 08:29 AM
Mar 12 2021 03:08 PM
Solution