Grace79
08-01-2007, 02:03 AM
Hello
I am looking for some help in searching a column for a word and for every instance it is found, finding the sum of a relative column in that row? The total will be on a different worksheet than the data being seached.
An example of the data being searched is attached, in reality the list is a few thousand rows!
So in the example, I would like to search for the word "winzip", count column C in every row where the word is found, and see the total on a different worksheet.
Any help would be much appreciated.
Thanks
Grace :bug:
I am looking for some help in searching a column for a word and for every instance it is found, finding the sum of a relative column in that row? The total will be on a different worksheet than the data being seached.
An example of the data being searched is attached, in reality the list is a few thousand rows!
So in the example, I would like to search for the word "winzip", count column C in every row where the word is found, and see the total on a different worksheet.
Any help would be much appreciated.
Thanks
Grace :bug: