Ignoring 0 and #DIV/0

Originally Posted by martindwilson

i did say
fix the div 0 first

Yes I edited my post when I saw that -- no need for SUMPRODUCT though... SUMIF/COUNTIF should suffice.

jj72uk, the issue is 0's (in addition to errors) are to be excluded from the AVERAGE ... an AVERAGE on it's own will not suffice... if using 2007 you can use AVERAGEIF else see prior posts.