Thread: summing ranges
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Markus Scheible[_2_] Markus Scheible[_2_] is offline
external usenet poster
 
Posts: 95
Default summing ranges


Hi newsgroup,

I've got some problems with summing ranges, maybe someone
could give me a tip?

I have a range of 744 entries and I want to sum every 24
cells from the first cell of the range - this sum should
be written in another range which also has 744 entries -
so this second range should get the sum, then 23 empty
cells and then the sum of the next 24 cells from the first
range...

Now I'm thinking about a solution with modulo but
therefore I would need the cell index or something else...
but maybe someone knows a better solution? Nevertheless,
how can I relatively address a cell within a range?

Thanks a lot in advance.

Best regards!
Markus
..