1. ## 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.

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

3. 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
•