Sum non blank values across - Excel
 

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!

Sum non blank values across - Excel
 

Hi
I think you have asked this question a couple of days ago and received
some answers from me and Aladin?
Have you tried them?

--
Regards
Frank Kabel
Frankfurt, Germany

"Shari Jayanithie" schrieb im Newsbeitrag
...
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!