Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
referring to a cell containing a file name | Excel Discussion (Misc queries) | |||
formula works when referring to one cell but not to another | New Users to Excel | |||
How to return a value Referring to the other cell. | Excel Worksheet Functions | |||
SUMIF function referring to values on different Worksheet | Excel Worksheet Functions | |||
cell text referring to tab name | Excel Worksheet Functions |