Assuming the table is in cols A to C, data from row2 down
Income | Expanses | Memo
| 10.00 | Food
| 5.00 | Gas
| 15.00| Food
Assume in say, E1 down is listed the text: Food, Gas, etc
Put in F1:
=SUMPRODUCT(--(ISNUMBER(SEARCH(E1,$C$2:$C$10))),$B$2:$B$10)
Copy F1 down
Col F will return the required results
Adapt the ranges to suit, but note that entire col references
cannot be used in SUMPRODUCT
And if the string search needs to be case sensitive,
replace SEARCH with FIND in the formula
(FIND is case sensitive)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"johnsvolition"
wrote in message
news:johnsvolition.1vdo6c_1126749938.7368@excelfor um-nospam.com...
Say I have 3 Rows:
Income | Expanses | Memo
| 10.00 | Food
| 5.00 | Gas
| 15.00| Food
Now I'm looking for a function that searches for a string such as
"Food" and then add all Values of the Expanses Tab of this certain tab,
so that all values of Food will be added automatically so that the
result of this would be 25.00...
I would really appreciate any help
--
johnsvolition
------------------------------------------------------------------------
johnsvolition's Profile:
http://www.excelforum.com/member.php...o&userid=27263
View this thread: http://www.excelforum.com/showthread...hreadid=467730