ExcelBanter - averageif with 3 criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - averageif with 3 criteria (https://www.excelbanter.com/excel-discussion-misc-queries/264675-averageif-3-criteria.html)

Rene

averageif with 3 criteria

Trying to average the results of this sumproduct formula. Searched the
questions already asked but only found average if for 1 or 2 criteria

SUMPRODUCT(--(S498:S534="A"),--(G498:G534=100),--(G498:G534<=200))/SUMPRODUCT(--(S498:S534="A"),--(G498:G534<""))

T. Valko

averageif with 3 criteria

See your other post

--
Biff
Microsoft Excel MVP

"Rene" wrote in message
...
Trying to average the results of this sumproduct formula. Searched the
questions already asked but only found average if for 1 or 2 criteria

SUMPRODUCT(--(S498:S534="A"),--(G498:G534=100),--(G498:G534<=200))/SUMPRODUCT(--(S498:S534="A"),--(G498:G534<""))

All times are GMT +1. The time now is 05:47 AM.