Solved: Find all instances of and then count

[Grace79]

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:

[RichardSchollar]

Hi Grace

By the sounds of it, a simple Sumif will do this (altho in your example, every row had Winzip in it?):

=SUMIF(Sheet1!A2:A12,"*Winzip*",Sheet1!C2:C12)

which will add up all amounts in col C on Sheet1 where the corresponding A column cell contains "Winzip".

Hope this helps!

Richard

[rory]

I think you just want a SUMIF formula:
=SUMIF(Sheet1!A:A,"*winzip*",Sheet1!C:C)

Regards,
Rory

[Grace79]

Wow - thanks for your quick replies!

I think I expected it to be alot more complicated for some reason. :yes

Richard - in the real life scenario, every line won't contain the word I am searching for!

Cheers
Grace