AVERAGEIFS but I want to ignore cells in a range that are non-numeric??

Hi All

Long time viewer, first time poster.

I'm trying to do an AVERAGEIFS formula and I want to ignore any cells that contain non integer values.

This is my current formula.. I have everything ready to go except for the last criteria which is ignoring non int values.

=AVERAGEIFS('Current Lot37'!G5:'Current Lot37'!G100,'Current Lot37'!C5:C100,C5,'Current Lot37'!G5:G157

Thanks!

Hi
you could try an array formula:

=AVERAGE(IF(MOD($A$1:$A$5,1)=0,$A$1:$A$5))

to enter an array formula copy the formula and press Control+Shift+Enter. It should appear in the formula bar in curly brackets