easy enough
=sumproduct((b3:b33="b")*(c3:c33="c")*a3:a33)
note the ranges MUST be the same size.

--
Don Guillett
SalesAid Software

"teeb" wrote in message
...

I'm trying to get the sum of a range in columb A, only if in the same
row in columb b has "text b" AND columb c has "text c"

Any help will be appreciated!


--
teeb
------------------------------------------------------------------------
teeb's Profile:
http://www.excelforum.com/member.php...o&userid=13172
View this thread: http://www.excelforum.com/showthread...hreadid=508930