Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#div/0 errors and blank cells
Hi wondering if anyone can help me with this one...
Have 31 cells in a row which i want to get the average value from, some of these 31 cellsmay or may not have data in them. The end coloum would be the one working out the average value of that row of cells. If no data is entered into any of the cells is it possible to get the average formular not to return a #div/0 error but instead just return a 0 figure? Obviously as soon as any data is entered the formular would work as normal but just want it not to return the error should no data be entered. The average figures obtained would then be used in a graph. sure must be a plain and simple answer to this.. Dean |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"If" statement returning blank gives downstream formula errors. | Excel Discussion (Misc queries) | |||
summing cells that have VALUE errors in them | Excel Worksheet Functions | |||
Count cells with numbers and ignore cells with errors | Excel Discussion (Misc queries) | |||
Sum some cells in column but not #n/a errors | Excel Discussion (Misc queries) | |||
Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions |