Hi April,
You need to use SUMPRODUCT
Check out
www.xldynamic.com/source/xld/SUMPRODUCT.html
I think you will find what you want (and more).
Ed
--
EdMac
------------------------------------------------------------------------
EdMac's Profile:
http://www.excelforum.com/member.php...o&userid=30736
View this thread:
http://www.excelforum.com/showthread...hreadid=533613