Hello Everyone,
I've been having an issue that has been so difficult to solve for me, that I created an account on this site JUST so I could ask it.
My current predicament is:
I have an Excel Workbook with 2 sheets: Member Statistics and Team Statistics
In Member Statistics, I have 3 member names and a column CALLS MADE (Column C; first value stats at C2) for each member for each date, i.e.,
DATE NAME CALLS MADE
1-Jan-2014 John 19
1-Jan-2014 Smith 17
1-Jan-2014 Holmes 22
2-Jan-2014 John 12
2-Jan-2014 Smith 3
2-Jan-2014 Holmes 16
3-Jan-2014 John 14
3-Jan-2014 Smith 15
3-Jan-2014 Holmes 20
There are no blank rows. Member names repeat every 3 rows, and dates are incremented by1, every 3 rows.
On the other sheet (Team Statistics), I have a column CALLS MADE (Column B; first value stats at B2)
DATE CALLS MADE
1-Jan-2014 58
2-Jan-2014 31
3-Jan-2014 49
I need a formula that adds the 3 CALLS MADE rows for every date, from the "Member Statistics" sheet, and enters the SUM value in the Calls Made column for that date, in the "Team Statistics" sheet
The formula that I tried is =SUM('Member Statistics'!C2:C4). This works fine, but I am unable to use the Fill (Down) command since the row numbers fail to increment in groups of 3, and I have too much data to enter the formula in each cell manually.
How can I make the row numbers increment in groups of 3, i.e.,
=SUM('Member Statistics'!C2:C4)
=SUM('Member Statistics'!C5:C7)
=SUM('Member Statistics'!C8:C10)
.
.
.
and so on?
Bookmarks