Using more than one column for criteria
 

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.

Using more than one column for criteria
 

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.

Using more than one column for criteria
 

Thank you, worked perfectly!

"Jim Thomlinson" wrote:

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.