Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Finding Duplicate Names from Different Lists... | Excel Discussion (Misc queries) | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
How can I find the common names in two columns of names? | Excel Discussion (Misc queries) |