I have a list of names on col C5:C35 with their values on O5:O35 and another list of names starting on column C40:C63 with their values on O40:O63, i am looking for a formula that sum the values from the matched names from both lists on col P40:P63. ig If the name Robert is on col C5 with a value of 5 on col O5 and the same name Robert is on col C45 with a value of 5 on col O45, i should get 10 on col P45, hope this make sense, thanks in advance for any help.
may index/match could help.
summatch.xlsx
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Hi vlady, thanks for your help, it does work perfect!! i'am stoke, i really appreciate for you taking the time and help me with this...
You welcome!
regards,
vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks