hi community

can some one kindly tell me why my output shows .. #N/A

the scenario is such:

I have 5 rows of numbers, example:

A1 = 1
A2 = 2
A3 = 0
A4 = 3
A5 = 4

I wanted to average out the 5 rows but I do not want the "A3" be inside the
average formula because it has a "0" value
I remembered seen this question with answer before in the Discussion Group,
and I tried it myself with this formula:

=average(if(a1:a5<0,a1:a5))

but the output shows "#N/A" and i checked the Error, it indicated the "#N/A"
is at the first set of cell range - a1:a5

can somebody kindly help to explain to me

thanks and very much appreciated :)
--
oldLearner57