Using more than one column for criteria

[Lori]

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.

 

[Jim Thomlinson]

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

 

[Lori]

Thank you, worked perfectly!

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