Sum non blank values across - Excel

  • Thread starter Thread starter Shari Jayanithie
  • Start date Start date
S

Shari Jayanithie

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
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Issues creating formulas 2
Count Values in same worksheet - Urgent please 1
Count values in Cells Across 1
Need Macro... 8
Multiple SUM's in a column 15
sum across cols using for/ next 6
Using the INDIRECT function across multiple worksheets 1

Back
Top