yup. sumproduct would work

=sumproduct(--(country range="US")*--(state range="California")*(last
range)

where country range is like A1:M1 or what have you

make sure your data cells don't have trailing spaces, you could
wildcard (*) your criteria or trim if it does.

this is a good resource:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html


--
MDubbelboer
------------------------------------------------------------------------
MDubbelboer's Profile: http://www.excelforum.com/member.php...o&userid=36330
View this thread: http://www.excelforum.com/showthread...hreadid=563318