K
KRK
Hello,
I have a long list of numbers (over 600) in a single column, say they are in
A1..A600 (they are daily meter readings) .
In column B I want to subtotal them in groups of 30, or 90, or 365 , or 7,
where the number of days being subtotalled is specified in another cell ?
So in B600 I would have =SUM(A571:A600) for 30 days, or =SUM(A511:A600) for
90 days etc. , where the starting cell A571 or A511 is determined by a
number, ie 30 or 90, in cell C600
How do I arrange for the first cell in the SUM( ) formula to be
determined in this way?
Can someone point me in the right direction please
Thanks as always
K
I have a long list of numbers (over 600) in a single column, say they are in
A1..A600 (they are daily meter readings) .
In column B I want to subtotal them in groups of 30, or 90, or 365 , or 7,
where the number of days being subtotalled is specified in another cell ?
So in B600 I would have =SUM(A571:A600) for 30 days, or =SUM(A511:A600) for
90 days etc. , where the starting cell A571 or A511 is determined by a
number, ie 30 or 90, in cell C600
How do I arrange for the first cell in the SUM( ) formula to be
determined in this way?
Can someone point me in the right direction please
Thanks as always
K