Try this:

=SUMPRODUCT((B1:B100="textb")*(C1:C100="textc")*A1 :A100)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"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