Greetings all!
Working Formula:
=SUMPRODUCT(--(GNC70901!$A$2:$A$20000<>""),--(GNC70901!$F$2:$F$20000=$B$3),--(LEFT(GNC70901!$C$2:$C$20000,2)<>"ER"),--(LEFT(GNC70901!$C$2:$C$20000,2)<>"ES"),--(GNC70901!$H$2:$H$20000>30))
Above formula gives me the total > 30.
I would like to calculate the average of the all the counts >30
Not sure how and where to add this array....thanks.
Regards,
rthakur
Working Formula:
=SUMPRODUCT(--(GNC70901!$A$2:$A$20000<>""),--(GNC70901!$F$2:$F$20000=$B$3),--(LEFT(GNC70901!$C$2:$C$20000,2)<>"ER"),--(LEFT(GNC70901!$C$2:$C$20000,2)<>"ES"),--(GNC70901!$H$2:$H$20000>30))
Above formula gives me the total > 30.
I would like to calculate the average of the all the counts >30
Not sure how and where to add this array....thanks.
Regards,
rthakur