| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
problem with an averaging formula
Dave,
It seems to do the trick. Thank You! "Dave Peterson" wrote: =if(count(b3:b6)=0,"",average(b3:b6)) (Check for some numbers in that range first.) Bobbie wrote: I'm trying to write a formula that will average each column A,B and C but if there isn't any numbers in the column leave the total blank instead of having the #DIV/0! show up. The formula I have used to get the totals is =average(B3:B6). The values in the total row get used on another formula on a different worksheet and the #DIV/0! messes up that formula. Thanks A B C 33.3 0.0 66.7 50.0 -100.0 -66.7 75.0 Total 18.8 #DIV/0! -5.6 -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging with a formula | Excel Discussion (Misc queries) | |||
| Averaging/Rounding Equation Problem | Excel Worksheet Functions | |||
| Averaging/Rounding Equation problem | Excel Discussion (Misc queries) | |||
| Averaging and Rounding problem | Excel Worksheet Functions | |||
| Formula for averaging times | Excel Discussion (Misc queries) | |||
Threaded Mode
