| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calc in excel
I am calculating the average of numerical values from the same cell of many
worksheets. some cells don't have available value. the calc returns error because it substitutes the empty cell with the value 0. How do you write a formulae that ignore the empty cell and does not include it in the calc? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calc = Manual & Do Not Calc b/4 SAVE | Excel Discussion (Misc queries) | |||
| save Excel calc' as the number | Excel Discussion (Misc queries) | |||
| My calc key on Excel changes box to "Text" Box and doesn't calc ? | Charts and Charting in Excel | |||
| auto calc on, but have to edit (f2) cells to force re-calc..help! | Excel Worksheet Functions | |||
| Excel Won't Calc? | Excel Worksheet Functions | |||
Threaded Mode
