Hello,
I would like to return the sum of all occurrences of the reference numbers in Sheet 1, copied over to Sheet 2.
Maybe a Vlookup combined with sumif? I am really struggling even though it must be simple I am sure...!
I wan to populate G4:G22.
Any help?
Thanks
Val
In G4:
and pull down.
Please Login or Register to view this content.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
I made a pivot table in the attached;
Thanks guys, I have both a formula and pivot table solution now.
Much appreciated! I had never thought of doing a pivot table for this...
All the best
Val
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks