sumif with multiple criteria

[Dartagnan]

Can you do a sumif with 2 or more criteria? I would like the sumif to look at 2 cells and then sum. For example cell A1 has 1/2001 and cell C1 has 6. I want the sum if A1 = 1/2001 and C1 = 6.

Can this be done?

 

[Aladin Akyurek]

On 2002-10-11 15:03, Dartagnan wrote:
Can you do a sumif with 2 or more criteria? I would like the sumif to look at 2 cells and then sum. For example cell A1 has 1/2001 and cell C1 has 6. I want the sum if A1 = 1/2001 and C1 = 6.

Can this be done?

You do not specify where to look using those 2 criteria...

=SUMPRODUCT((Range1=A1)*(Range2=C1),Range3)

 

[Dartagnan]

I am not sure I follow you. I am going to look through 2 columns and if the criteria in both columns match then give me the sum.

The 1st criteria(1/2002) is located in column A. The 2nd criteria(6) is located in column C. The column I want to sum is column B. So if column A has 1/2001 and column C has 6 then give me the sum from column B.

Thank you.

 

[Aladin Akyurek]

On 2002-10-11 15:34, Dartagnan wrote:
I am not sure I follow you. I am going to look through 2 columns and if the criteria in both columns match then give me the sum.

The 1st criteria(1/2002) is located in column A. The 2nd criteria(6) is located in column C. The column I want to sum is column B. So if column A has 1/2001 and column C has 6 then give me the sum from column B.

Thank you.

=SUMPRODUCT(($A$2:$A$100=E1)*($C$2:$C$100=F1),$B$2:$B$100)

Enter in E1 the criterion 1/2001 and in E2 the criterion 6.

 

[Dartagnan]

That works great!!