| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Blank cell with average formula
Hi,
How can I leave a answer cell blank if the range of cells I am using to get an average answer are blank? i.e. I am using this formula =AVERAGE(D26:D30) in D31. What formula do I use if I wish this formula to work but leave a blank cell of there are no numbers in D26:D30? Thank you for you help in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average from first non-blank cell | Excel Discussion (Misc queries) | |||
| How to return a blank formula cell if the reference is blank? | Excel Worksheet Functions | |||
| Array Formula - Average from every other cell | Excel Discussion (Misc queries) | |||
| Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
| Formula to average the last 4 non-blank numerical cells of a row? | Excel Worksheet Functions | |||
Threaded Mode
