Home |
Search |
Today's Posts |
#1
|
|||
|
|||
want the avg of a range BUT
I have a column and say i have 6 numbers in the column. I
want the avg of those numbers. I do sum and then divide by the amount of numbers. BUT when i put another number so now there are 7 it still is dividing by 6. How do i tell it to dived by the number of filled cells in a colmn? thanks for you help rich |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create range bar graph | Charts and Charting in Excel | |||
Dynamic Print Range Help | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions | |||
Defined range difficulty | Excel Discussion (Misc queries) | |||
named range refers to: in a chart | Excel Discussion (Misc queries) |