Absolutely wonderful. Thank you for your help Domenic. Sandy
"Domenic" wrote:
In article ,
"sandy" wrote:
I have a column with 10,000 rows of numbers. I need to sum a1:a5, a6:a10,
a11:a15, and so on in groups of five, for all 10,000 rows. How can I do
this? Thanks much.
Try...
B1, copied down:
=SUM(OFFSET($A$1,(ROW()-ROW($B$1)+1)*5-5,0,5))
Hope this helps!
|