Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find values across a row and return a text value from the same column [email protected] Excel Discussion (Misc queries) 4 March 20th 13 02:52 PM
Find max value from 3 cells, return text, but 2 max values same! Struggling in Sheffield[_2_] New Users to Excel 5 March 7th 09 05:34 PM
Find Duplicate Values and Return Another Value [email protected] Excel Worksheet Functions 2 January 18th 07 06:25 PM
find largest values, then return corresponding row values. neurotypical Excel Discussion (Misc queries) 7 May 24th 06 10:27 PM
Find two values in worksheet to return one value Correna Excel Worksheet Functions 10 May 4th 06 10:22 PM


All times are GMT +1. The time now is 04:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"