how many times a specific value is in a range...?

[Dan B]

Hi,

I have a sheet that has several columns that contain numbers, yeses, no's
and N/A's.

I need formulas to count how many times a specific value in one column. For
example, how many times does the number 9 show up in column G, rows 8-516.
BUT...instead of giving me the count, I need a percentage. G519 has a count
of everything in G8-G516. So really, what percent of everything in G8-G516
are 9's.

From there I can copy the formula and edit as need to find out the
percentage of yeses, no's etc.

Thanks!!

Dan

 

[Gord Dibben]

Dan

For the percentage of 9's

=COUNTIF(G8:G516,9)/COUNTA(G8:G516)

With the Count of all in G19 I guess

=COUNTIF(G8:G516)/G519 will suffice.

Format to Percent.


Gord Dibben MS Excel MVP

 

[Dan B]

Perfect!!! That was exactly what I needed.

Thanks.