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