Hello,
I have the date below (just a sample). I used =SUMIFS(Count_of_date,client,"Bronx-Lebanon",day_of_the_week,{"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"}) to try to get the subtotals for each day of the week on column E and then I would divide that subtotal by the number of reviews for each time in the day to get a "division factor". My ultimate goal is to get to the division factor, but I can not go passed the fact that it is not summing by day of the week - all days return me 58 reviews when that's the sum for Sunday. If I get this to work, I could even try to divide D for the working formula and get the division factor straight. Any help will be appreciated! Maybe there is a much easier way to do this.
<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>
I have the date below (just a sample). I used =SUMIFS(Count_of_date,client,"Bronx-Lebanon",day_of_the_week,{"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"}) to try to get the subtotals for each day of the week on column E and then I would divide that subtotal by the number of reviews for each time in the day to get a "division factor". My ultimate goal is to get to the division factor, but I can not go passed the fact that it is not summing by day of the week - all days return me 58 reviews when that's the sum for Sunday. If I get this to work, I could even try to divide D for the working formula and get the division factor straight. Any help will be appreciated! Maybe there is a much easier way to do this.
Client | Day of Week | Date of Review | Count of Date of Review | Subtotals by day of the week | Division Factor |
Hospital 1 | Sunday | 7 AM | 1 | 58 | 2% |
Hospital 1 | Sunday | 8 AM | 3 | 58 | |
Hospital 1 | Sunday | 9 AM | 3 | 58 | |
Hospital 1 | Sunday | 10 AM | 3 | 58 | |
Hospital 1 | Sunday | 11 AM | 6 | 58 | |
Hospital 1 | Monday | 7 AM | 10 | 58 | |
Hospital 1 | Monday | 8 AM | 15 | 58 | |
Hospital 1 | Monday | 9 AM | 3 | 58 | |
Hospital 1 | Monday | 10 AM | 5 | 58 | |
Hospital 1 | Monday | 11 AM | 7 | 58 | |
Hospital 1 | Tuesday | 7 AM | 8 | 58 | |
Hospital 1 | Tuesday | 8 AM | 11 | 58 | |
Hospital 1 | Tuesday | 9 AM | 12 | 58 | |
Hospital 1 | Tuesday | 10 AM | 2 | 58 | |
Hospital 1 | Tuesday | 11 AM | 4 | 58 |
<tbody>
</tbody><colgroup><col><col><col><col><col><col></colgroup>