Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding an average of a list that could have 0 to 10 numbers in it
My list, see example below may have a number in each row or it may not. I
trying to write a formula that would average the numbers no matter how many there were. Example if there were 4 cells filled each with a number, the formula would divide the sum by 4. if there were 5, the formula would recognize there are 5 and would divide the sum by 5 and so on. Thanks List Header 0 0 0 51.71 0 52.79 0 50.56 0 0 ????? This is the average ( which would be 51.68 in this case )of how ever many actual numbers are in the list from 0 to 10 numbers possible. What would be the formula? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average the last 7 numbers on a list | Excel Worksheet Functions | |||
I need help finding an average | Excel Discussion (Misc queries) | |||
finding the median from a list of unsorted numbers | Excel Discussion (Misc queries) | |||
Finding a predetermined Sum from a List of Numbers | Excel Discussion (Misc queries) | |||
Finding the average time | Excel Worksheet Functions |