Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need a formula
I need a formula that will compute an average for a random number of cells,
discounting other formulas in those cells as well as blank cells or any containing zeros. Ex: AVERAGE( A1, B4, C18) Final result must be an average of only those cells with a number entered (as the result of another formula) -- dbconn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|