Thread: averageif with 3 crieteria
View Single Post
  #3  
Old May 29th, 2010, 12:38 AM posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_]
external usenet poster
  
Posts: 1,764
Default averageif with 3 crieteria
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

"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