Average Random cells excluding zeros

[shnybltz]

I have two random cells which at any time may or may not contain a zero that I need to average.
Example 1: H16 = 2.08, H27 = 4.67 Easy average formula (=Average(H16,H27)
Example 2: H16 = 0, H27 = 4.67 How do you average this to exclude zeros?

[NBVC]

Try:

=IF(H16=0,H27,IF(H27=0,H16,AVERAGE(H16,H27))

[shnybltz]

Try:

=IF(H16=0,H27,IF(H27=0,H16,AVERAGE(H16,H27))

Worked!! Thank you very much.

[bebo021999]

Try this:
=SUM(H16,H27)/IF(H16=0,1,IF(H27=0,1,2))

Or
=SUM(H16,H27)/IF(OR(H16=0,H27=0),1,2)