averages
Hi,
If you are going to use the last suggestion it would be safer to use
SUM(A1:A10)/COUNTIF(A1:A10,"<0")
Alternatively in 2007 you should consider this:
=AVERAGEIF(A1:A10,"<0")
In all versions you could also use
=AVERAGE(IF(A1:A10<0,A1:A10,""))
This formula is array entered (press Shift+Ctrl+Enter to enter it rather
than Enter)
--
Thanks,
Shane Devenshire
"tommy" wrote:
Hi, I have a column with a line of numbers and I have set an average at the
bottom using Autosum but it is dividing the zeros as well is there any way
around this?.
Thanks in advance, Barry.
|