averageif with 3 crieteria

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
 
T

T. Valko

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?
 
A

Ashish Mathur

Hi,

Try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 

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

Top