=SUMIF(A:A,"Apples",B:B)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"WendyBTR8860" wrote in message
...
I would like to create a formula in one cell that would calculate amounts
in
a given range. For example:

Column A Column B
Apples $10
Oranges $20
Bananas $15
Apples $10
Pears $50
Apples $10

From the chart above, I can see that the amount spent on Apples was $30. I
would like to create a formula that would lookup Apples in column A and
total
the corresponding amount from column B (without having to sort column A).

Any help is greatly appreciated. Thank you!