Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Nov 2002
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    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
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    New Lounger
    Join Date
    Nov 2002
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
  •