R
Rene
SUMPRODUCT(--(S498:S534="a"),--(G498:G534>=100),--(G498:G534<=200))/SUMPRODUCT(--(S498:S534="a"),--(G498:G534<>""))
I searched questions already answered but did not see averageif with 3
criteria
I want the formula to return the average. Thanks in advance
I searched questions already answered but did not see averageif with 3
criteria
I want the formula to return the average. Thanks in advance