Sum multiple conditions

**creativefusion** · 05-13-2009, 12:27 AM

Hi All,

I am wanting to sum data in column C based on specific conditions in column A & B.

If column A (Full / Split Case) = "VP" & If column B (Temp) = "2", then sum the value in column C.

I have attached an example file for reference.

Thanks in advance.

**JBeaucaire** · 05-13-2009, 12:34 AM

One way with a SUMPRODUCT() formula:

=SUMPRODUCT(--($A$2:$A$12="VP"),--($B$2:$B$12=2),$C$2:$C$12)

If you replace the red values with cell references you could dynamically change that formula by changing those cell values.

**Paul** · 05-13-2009, 12:37 AM

Hello Creativefusion,

Try this formula on for size:

=SUMPRODUCT(--(UPPER($A$2:$A$12)="VP")*($B$2:$B$12=2),$C$2:$C$12)

**creativefusion** · 05-13-2009, 01:39 AM

Formula's work a treat. Its exactly what I was looking for.

Thanks heaps guy's.

**creativefusion** · 05-13-2009, 01:59 AM

Originally Posted by JBeaucaire

One way with a SUMPRODUCT() formula:

=SUMPRODUCT(--($A$2:$A$12="VP"),--($B$2:$B$12=2),$C$2:$C$12)

If you replace the red values with cell references you could dynamically change that formula by changing those cell values.

Please disregard previous