How to do summation with 2 conditions?

[Lewis Koh]

Hi,

This may look like the "How to Count with 2 conditions" but it is different.

How do I do summation with 2 conditions?

Example:
A1 = Apple
A2 = Pear
A3 = Orange
A4 = Starfruit
A5 = Apple
A6= Apple

C1 = 1
C2 = 2
C3 = 3
C4 = 4
C5 = 5
C6= 6

D1 = SUM(C1:C6) if A1:A6="Apple" = 12

[stanleydgromjr]

Lewis Koh,

The formula in D1:
=SUMIF($A$1:$A$6,"Apple",$C$1:$C$6)

Or, the formula in D1 copied down:
=SUMIF($A$1:$A$6,$A1,$C$1:$C$6)

Or:
=SUMPRODUCT(--($A$1:$A$6="Apple"),$C$1:$C$6)

[arthurbr]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.