| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Text, Then Return the Sum of its values in Col D
I am looking to find a piece of VBA that will look up certain text in a column and where found return the values in another column
Example Say I'm looking for the number "America" appears in Column B, then for each instance add together the values in Column D The Text in Column B will be of multiple words, thus in any line where "America" appears in Cilumn B then sum up the values associated with this in Column D |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find values across a row and return a text value from the same column | Excel Discussion (Misc queries) | |||
| Find max value from 3 cells, return text, but 2 max values same! | New Users to Excel | |||
| Find Duplicate Values and Return Another Value | Excel Worksheet Functions | |||
| find largest values, then return corresponding row values. | Excel Discussion (Misc queries) | |||
| Find two values in worksheet to return one value | Excel Worksheet Functions | |||
Linear Mode
