I have a set of numbers in MS Excel. I want to do the average function in column, but I do not want to include "0". Could anyone give me the function?

Thanks indeed :)

What version of Excel are you using? If you're using Excel 2007+ then look at using the AVERAGEIF() function.

I`m using Excel 2003

Then something like:

=SUMIF(A:A, ">0", A:A) / COUNTIF(A:A, ">0")

It works!! Thank you JBeaucaire :)

Hey, for Ms. Access, could you give the syntax please?

Thanks

Sorry, I don't use Access.