averageif with 3 crieteria
I want the formula to return the average.
The average of what?
It looks like you're calculating the percentage of cells that meet a
condition. Why do you think you need/want an "averageif" formula?
What version of Excel are you using?
--
Biff
Microsoft Excel MVP
"Rene" wrote in message
...
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
|