Sum if cell contains text string

[pollfre]

Hi guys,

below is the code I started:

Please Login or Register  to view this content.

The range contains a list of names. I want the sub to start with the first name and sum the value(long) which are in 7 columns to the left of the text string. Once this procedure has been done for the first name, it should go back up to the second name and do the same and so on. Once done I will return the name (cell A1 in another sheet) and its respective sum (cell B1 in another sheet) so that I have the list of names with their respective sum.
Could you help on the sum function using an offset of 7 columns to the left?

Thanks!!!

[nathansav]

I dont think you need the cell.offset in ""'s also it should be offset from ParentCompany as you are not using a var called cell

something like

Please Login or Register  to view this content.

[pollfre]

I can directly select the range this is not really an issue. The sub currently does not select the text strings in the range one by one. Instead it takes them all at the same time and performs the total sum of the other range...

[nathansav]

sorry i dont understand what you want, your post says "Could you help on the sum function using an offset of 7 columns to the left?"

[pollfre]

This is what I am looking for

"For each unique text string in the RangeParentCompany, select the corresponding number which is 7 columns to the left of the text string
'then reiterate the task till you are down in the range by summing all the numbers. Start again with a new text string"

[nathansav]

Well you dont need sum then, you just need parentcompany.offset(0,7).value

are you asking for someone to advise on doing the Unique bit of your list?