Percentage formula

A

AbbyLT

Hi! I need a simple formula that will tell me what percentage of a column has, for instance, '1' as the value, values range from 1 - 4, sounds simple but I'm getting nowhere! Any help would be appreciated, thanks - I'm working with statistics.
 
M

Mike A

Hi! I need a simple formula that will tell me what percentage of a column has, for instance, '1' as the value, values range from 1 - 4, sounds simple but I'm getting nowhere! Any help would be appreciated, thanks - I'm working with statistics.
Click to expand...

Try this (example tests entire column A):

=COUNTIF(A:A,1)/COUNTA(A:A)*100


Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers
 
A

Art

Abby,

Assume that your numbers are in A1:A13. Try the following:

=COUNTIF(A1:A13,1)/COUNT(A1:A13)

Art
 
Top