Percentage of total…GOOGLE Sheets

Topic

New Reply

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

Reply | Quote

Replies

You can use:
=COUNTIFS(B:B,”>=0″,B:B,”7″,B:B,”10″)/count(B:B)

for the three values.

Reply | Quote

rory,

Perfect. Thank you very much.

Reply | Quote