Assume your database is called MyTable

=AVERAGE(IF(MyTable<0,MyTable))

entered with ctrl + shift & enter

Regards,

Peo Sjoblom


"kbschlepp" wrote:

I would like to do some calculations with my database but do not want the
zeroes averaged in. Is there a way to eliminate all of the zeroes in my
spreadsheet?