Adding Cells based on number 3

[Denz]

Hi All,

Is there a way of working out how many cells should be added in a formula based upon the month number.

So for example if the month is 1 then the formula should be =A1

if month is 2 the formula should be =a1+a2

if month is 3 the formula should be =a1+a2+a3

etc etc

i just can't work out how to do this!!

Thanks for you help!

 

[SkipVought]

There's that D*%# crystal ball again!

I think I had

COLUMN-bind,when I REALLY wanted

ROW-gain!

;-)

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[Denz]

Z,

Your a GENIUS!!!

Many Thanks mate, your post really helped ! (or was it the cystal ball???? )



Dave