I am not sure if these are the right functions for trying to accomplish what i want. I am trying to have a function determine for me the total for each customer.
Ex:
A B
Cust. A 1
Cust. A 2
Cust. A 7
Cust. B 8
Cust. C 1
Cust. C 1
Cust. D 2
Cust. D 2
Cust. D 2
Cust. D 2
Output
Cust. A = 10
Cust. B = 8
Cust. C = 2
Cust. D = 8
Try this
=SUMIF($A$2:$A$11,C2,$B$2:$B$11)
Cust. A Cust. A Cust. A Cust. B Cust. A Cust. C Cust. B Cust. D Cust. C Cust. C Cust. D Cust. D Cust. D Cust. D
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Exactly what I was looking for. This worked a treat. Cheers.
Originally Posted by AlKey
Is Dave = Tectec...?
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
Vikas, doesnt look like it (different IP), probably a new member that happened to need the same answer
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Re: Help with Vlookup and Sumif?
Yes different person. I was just about to post the same thing and seen this post. Worked for what I was after.
Sorry...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks