You can either use an array formula or sumproduct. Here is sumproduct...
=sumproduct(--($A$1:$A$10 = "P"), --($B$1:$B$10 = "mbc"), $C$1:$C$10)
Here is a link that explains the formula...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...
Jim Thomlinson
"Lori" wrote:
Hi, I have the following question. I need to add the following:
If Column A has a "P" in it and Column B has "mbc" in it then I need Column
C to add.