Looking for function to pick out names and at values from the same row
 

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

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