View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ghnogueira ghnogueira is offline
external usenet poster
 
Posts: 6
Default Sum values referring to a cell with same value

Hey. I want to know what's the easiest way of doing that... I'll try to
explain, it's simple

Let's say I have a table with many fruits in one cell, and the amount of
them on the cell next to them. I want to sum all the "pears" that are on my
table. How do I do it?

e.g.

A B
1 apple 5
2 pear 10
3 banana 8
4 pear 6
5 apple 6
6 pear 1

I want a cell that will give me 17 when the string looked for is pear
(B2+B4+B6), or 11 when it looks for apple (B1+B5)... hope it was easy to
understand