Adjust AverageIf Formula

[dunmore83]

Hi,

I have the following formula;

=IF(G36="","",AVERAGEIF(INDEX('Heifers-Steers-Day'!$U$36:$NU$1214,0,MATCH($G36,'Heifers-Steers-Day'!$U$32:$NU$32,0)),">0"))

I need to add 2 extra conditions to the ">0" condition. These are;

'Heifers-Steers-Day'!$G$36:$G$1214,">="&$V36
'Heifers-Steers-Day'!$G$36:$G$1214,"<="&$Y36

Any helpers ??

 

[liveinhope]

what version of excel are you using ? If you have 2007 or later use AVERAGEIFS instead of AVERAGEIF

note that the syntax is a bit different =averageifs(average RANGE,CRITERA RANGE1, CRITERIA1, CRITERIA RANGE2, CRITERIA2) ETC