Can someone help me please?

I know pivots tables will provide this information but they are to memory
intensive.

I want to be able sum the figures in a column if another column meets a text
value in that same row.

Orange, 2
Lemon, 4
Apple, 7
Peach, 3
Orange, 5

So I get a SUM result for Oranges as 7

Thanks

--
Mark