A brute force work around is to set up a column (say Y) as a dummy column and
enter
=E92 in Y1,=E71in Y2,etc.
you then have the contiguous cells necessary for Sumif or sum product methods.

"Keithlearn" wrote:

I am trying to average cells that are non contingous, and also need to
exlcude any zero's in the mix. All the posts I have read count on either
sumproduct or countif both of which don't seem to be able to accept non
contingous cells. Is there something that might be able to help.

An example of the simple average formula is

=AVERAGE(E92,E71,E50,E29,E8)

Thanks,

Keith