Im trying to solve a relative simple problem, but I cannot find a suitable formula to help me.
Excel.jpg
I need a way of totaling up values associated with a list of names, some of which have multiple entries. So looking at my screen shot:
"Bob" would have 12 in the right hand column of the right hand table
"Jane" would have 8 etc etc...
I've tried using VLOOKUP for this but it only returns the first instance of the name instead of the sum of all the instances.
Hope you can help, Thanks!
Mitch
Have you tried SUMIF?
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
In G2 enter the formulaand copy down
Please Login or Register to view this content.
That's perfect, thankyou!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks