| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas not data 0
Hi guys
I want to somehow create a formula, which give me the following results... I want it to SUM a serious of cells e.g. SUM(A1:A5) However, if there are no results in cells A1 to A5, I don't want the SUM cell to display a 0 I want for it to stay blank. Please advise thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting # of Formulas in a column with formulas and entered data | Excel Worksheet Functions | |||
| Using Formulas for Data Validation | Excel Worksheet Functions | |||
| How to sort data w/ formulas? ... | Excel Discussion (Misc queries) | |||
| How do I calculate formulas for yes/no data | Excel Worksheet Functions | |||
| Save Data not Formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
