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 |
#2
|
|||
|
|||
How about
=AVERAGE(Range) -- Regards, Peo Sjoblom "bullcrappy" wrote in message ... 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 |
#3
|
|||
|
|||
use the AVERAGE function
=AVERAGE(A:A) -- HTH RP (remove nothere from the email address if mailing direct) "bullcrappy" wrote in message ... 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 |
Reply |
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) |