=SUMPRODUCT(A1:10,--(B1:B10="text b"),--(C1:C10="text c"))

should work.

"teeb" wrote:


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