Actually, the first formula can be written like:

=SUMIF(A1:G1,"0")/COUNTIF(A1:G1,"0")

Biff

"Biff" wrote in message
...
Hi!

Try one of these:

=SUMIF(A1:G1,"0",A1:G1)/COUNTIF(A1:G1,"0")

This one is an array and must be entered using the key combo of
CTRL,SHIFT,ENTER:

=AVERAGE(IF(A1:G10,A1:G1))

Biff

"Chase" wrote in message
...
I have a row of various #s and I would like to take the average of those
numbers only if they are greater than 0, if they are less than or equal
to 0
I would like to omit them.

How can create a formula to reflect this?

Thanks,
CT