Quick question.
Is there a quick way to look up the unique part #s in column E and add up the total qty's in column B and for the info to be summarized in a table?
Not sure if I should use vlookup or countif....?
Sample.xlsx
Quick question.
Is there a quick way to look up the unique part #s in column E and add up the total qty's in column B and for the info to be summarized in a table?
Not sure if I should use vlookup or countif....?
Sample.xlsx
Use a Pivot Table. perfect for this sort of thing.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
If you want to "add up", you probably need SUMIF or SUMIFS.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I note this is marked solved. Any feedback on the preferred solution? Or even a "thank you"?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks