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