sumif

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sumif - 04 Feb 2008 02:17 GMT

If I have two column as below:
(ColumnA) (Column B)
1. Apple 35
2. Orange 5
3. Banana 9
4. Pear 25
5. Banana 18
6. Apple 56
7. Orange 36
8. watermelon 66
9. Orange 14
10.Apple 5
If I use SumIf like this =SUMIF(A1:A5,"Banana",B1:B5), it only come up 18+9
= 27.
How can I sum up more than two items in the ColumA, like sum up "Pear" +
"Apple" +"Orange" together.

Reply to this Message

Dave Peterson - 04 Feb 2008 02:32 GMT

You could use multiple =sumif()'s:

=SUMIF(A1:A5,"apple",B1:B5)
+SUMIF(A1:A5,"pear",B1:B5)
+SUMIF(A1:A5,"orange",B1:B5)

Or you could use something like:
=sum(SUMIF(A1:A5,{"apple","pear","orange"},B1:B5))

Adjust your range...I bet it doesn't stop with row 5.

> If I have two column as below:
> (ColumnA) (Column B)
[quoted text clipped - 12 lines]
> How can I sum up more than two items in the ColumA, like sum up "Pear" +
> "Apple" +"Orange" together.

Signature

Dave Peterson

Reply to this Message