Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    West Seneca, NY
    Posts
    150
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Percentage of total...GOOGLE Sheets

    I'm back again for help. Last time the help you guys afforded me was fantastic.

    Today's problem:

    I have a column of numbers that represent a span of days...0 to 7 days, 8 to 10 days, and 11 or greater. This column
    will grow each day so there will be a maximum of 365 cells or days. The number in each cell will change depending on
    when the particular job is completed. When completed the number will remain frozen for that cell.
    In a separate cell in the spreadsheet I to want express as a percentage of the total how many days fall within each of the three groups.

    I'm using GOOGLE SHEETS.

    Here is sample of what the columns looks like

    Col A Col B
    Completion Avg days
    date late/early

    01/09/15 3
    01/10/15 0
    01/16/15 6
    02/06/15 12
    02/06/15 9
    01/29/15 1
    02/08/15 8

    I want to calculate the percentage of the days that are within 0 to 7 days, 8 to 10 days, and greater that 10 days.
    So in this example there are 7 days worth of data. 4 of those fall with in the 0 to 7 day span (57%), 2 fall within the 8 to 10 day (28.5%) and 1 falls beyond the 10 day range (14.5%). Keep in mind this is a dynamic list and can grow up to 365 days.

    Thanks

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    You can use:
    =COUNTIFS(B:B,">=0",B:B,"<=7")/count(B:B)
    =COUNTIFS(B:B,">7",B:B,"<=10")/count(B:B)
    =COUNTIF(B:B,">10")/count(B:B)

    for the three values.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    West Seneca, NY
    Posts
    150
    Thanks
    1
    Thanked 0 Times in 0 Posts
    rory,

    Perfect. Thank you very much.

Posting Permissions

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