# Thread: Percentage Formula (MS OFFICE 2000 PRO)

1. ## Percentage Formula (MS OFFICE 2000 PRO)

I have a column of data with numbers 1-4 for 159 rows. I have to figure out percents for each number, like all the ones make up for 26% of the 159, and 2s are 32% and so on. Is there a formula to create an auto percentage?

2. ## Re: Percentage Formula (MS OFFICE 2000 PRO)

Hi Clinton,

Say your data are in A1:A159, then the following formulae will work:
=COUNTIF(A1:A159,1)/COUNT(A1:A159)
=COUNTIF(A1:A159,2)/COUNT(A1:A159)
=COUNTIF(A1:A159,3)/COUNT(A1:A159)
=COUNTIF(A1:A159,4)/COUNT(A1:A159)
to return the counts as decimals. Format the results to percentage and you'll have your answers. You'll note that I didn't simply divide the counts by 159 - just in case some of the cells don't have numbers in them.

Cheers

3. ## Re: Percentage Formula (MS OFFICE 2000 PRO)

Thank you very much, and yes not all of the cells have a number in them. Thanks again

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•