I'm trying to get a sum by Month (from dates in row 1) and by group (in column A) using sumifs. but am stumped. suggestions?
<tbody>
</tbody>
My formula for B8 is
A | B | C | D | E | F | |
1 | WEEKLY | 10/05 | 10/12 | 10/19 | 10/26 | 11/02 |
2 | Group1 | 91 | 12 | 33 | 64 | 29 |
3 | Group2 | 3 | 6 | 8 | 1 | 0 |
4 | Group3 | 12 | 69 | 3 | 4 | 56 |
5 | ||||||
6 | ||||||
7 | MONTHLY | 10/26 | 11/23 | 12/28 | 1/25 | |
8 | Group1 | ? | ? | ? | ? | |
9 | Group2 | ? | ? | ? | ? | |
10 | Group3 | ? | ? | ? | ? | |
11 |
<tbody>
</tbody>
My formula for B8 is
Code:
=SUMIFS(B2:F4,$A2:A4,B8,B1:F1,">="&A7-26,B1:F1,"<="&A7)
Last edited: