| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blank Values in Excel Charts | Excel Discussion (Misc queries) | |||
| Excel formula to return all non-blank values | Excel Discussion (Misc queries) | |||
| Not showing blank and non blank items in filter mode for values | Excel Worksheet Functions | |||
| display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
| Excel returns blank values using ADO/VB | Excel Programming | |||
Threaded Mode
