Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and AVERAGE
Hi,
I have a column of numbers, some of which are zero. I want to obtain the average of the numbers in the column and exclude the zeros from the calculation. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and AVERAGE
Hi James
Assuming your range is A1:A50 the formula would be =AVERAGE(IF(A1:A50<0,A1:A50)) entered using CONTROL & SHIFT & ENTER Hope this helps -- Cheers JulieD julied_ng at hctsReMoVeThIs dot net dot au "James" wrote: Hi, I have a column of numbers, some of which are zero. I want to obtain the average of the numbers in the column and exclude the zeros from the calculation. Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF and AVERAGE
On Wed, 4 Jan 2006 19:14:02 -0800, "James"
wrote: Hi, I have a column of numbers, some of which are zero. I want to obtain the average of the numbers in the column and exclude the zeros from the calculation. Thanks! =SUM(rng)/COUNTIF(rng,"<0") where rng is your reference to the column of numbers. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
plotted Average | Charts and Charting in Excel | |||
Weighed Average of a weiged average when there are blanks | Excel Discussion (Misc queries) | |||
What is this kind of average called? | Excel Worksheet Functions | |||
average function in Excel 2002 | New Users to Excel | |||
Average the Last Five Cells in a Column | Excel Worksheet Functions |