averageif with 3 criteria

R

Rene

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<>""))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

averageif with 3 crieteria 2
Averageifs - criteria is cell is not blank 1
AVERAGEIFS Multiple Criteria: use an Array? 7
sumproduct() function resulted in an error #DIV/0 2
How to use AVERAGEIFS for a date range 0
Average problem 1
Conditional AVERAGEIFS 6
Standard Deviation and Averages based on criteria 2

Top