How I use SUMIF & AND
 

Thanks for your help.

Can I use AVERAGE function also instead of SUM?


--
rajgopal
------------------------------------------------------------------------
rajgopal's Profile: http://www.excelforum.com/member.php...fo&userid=7281
View this thread: http://www.excelforum.com/showthread...hreadid=274667

rajgopal Wrote:
Thanks for your help.

Can I use AVERAGE function also instead of SUM?

Yes. You can use Paul's formula and change SUM to AVERAGE...

=AVERAGE(IF((A2:A10="east")*(B2:B10="type A"),C2:C10))

...entered using CONTROL+SHIFT+ENTER.


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=274667