| 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 |
| 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) | |||
Threaded Mode
