F
FMMM
I"m trying to usage the average function to average all numbers excluding 0.
Here's how i set up the function:
A B C D
7
8 JAN FEB MAR
9 Apples Bought 0 839 9,206
using this formula AVERAGE(IF(B99<>0,B99,"")) the result should be
5022.5. This is what is shown when i click on the function bar to look at the
formula but on my spreadsheet it gives me and error #VALUE. Do you know why
this is?
FMMM
Here's how i set up the function:
A B C D
7
8 JAN FEB MAR
9 Apples Bought 0 839 9,206
using this formula AVERAGE(IF(B99<>0,B99,"")) the result should be
5022.5. This is what is shown when i click on the function bar to look at the
formula but on my spreadsheet it gives me and error #VALUE. Do you know why
this is?
FMMM