Percentage formula

[Guest]

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.

 

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

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

 

[Guest]

Abby,

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

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

Art

 

[Guest]

Thanks guys that's great, and a weight off my mind!