Hi,

This question is in relation to Excel. Can somebody please let me know
how to do the following.

I need to sum a certain number of cells across.
Eg: Value appears in cell E14 (Eg 36)
I need to sum the values of the nonblank 36 cells across starting from
Cell Q14.

(Also, please note value in Cell E14 will change everymonth. Ie it will
increase by 1 next month. As a result I need to sum across the values of
the 37 non blank cells starting from Q14)

Please help.
Thanks

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!