Summing ranges

Giganews Newsgroups
Subject: Summing ranges
Posted by:  Hru48 (Hru48.27nl7a_1147368001.0662@excelforum-nospam.com)
Date: Thu, 11 May 2006

Hey,

I know this has been gone over before but I'm still having a wee bit of
difficulty - I have a set of numbers which I need to sum every month but
every month the amount of numbers (one month it would be (sum c17:c22)
the next it could be (sum c17:c30) etc) in the set changes.

The set of numbers start on cell c17 and have another set of numbers
after them after a gap of blank cells.

So I'm thinking I need a range that will select the cells until it
comes to an empty one.. maybe a do while loop? and then I could just
put a sum funtion at the top..

Let me know if you have any thoughts.

Many thanks

Hayley

--
Hru48
------------------------------------------------------------------------
Hru48's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=24895
View this thread:http://www.excelforum.com/showthread.php?threadid=541192

Replies