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

D

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the number of times a cell value is within a specific range 4
Count based on 2 conditions 4
counting how many times a certain month appears 3
Run macro according to value of a cell 1
Count how many times a phrase comes up? 3
counting the occurrence of specific text within a date range 4
Count the times a specific character appears in a cell 3
Counting items with a specific quanitifier in a date range 3

Top