=sumproduct((a1:a1000="type")*(c1:c1000="month")*( b1:b1000))
where type is the type you want, and month is the month you want
see also
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
duane
------------------------------------------------------------------------
duane's Profile:
http://www.excelforum.com/member.php...o&userid=11624
View this thread:
http://www.excelforum.com/showthread...hreadid=384297