Hi,

Here's 1 way an array formula

=AVERAGE(IF(A1:A20<0,IF(A1:A20<"",A1:A20)))

This is an array formula which must be entered by pressing CTRL+Shift+Enter
'and not just Enter. If you do it correctly then Excel will put curly brackets
'around the formula {}. You can't type these yourself. If you edit the formula
'you must enter it again with CTRL+Shift+Enter.

Mike

"Gudmundur" wrote:

I am using the average function in a large documents for different time
periods. Some time periods have ZERO, which bias the average.

Can I use the average function but not have it count zeros in the total?