Thread: drop down list and sum
View Single Post
 
Old 03-05-2018, 06:20 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2010 32bit
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
You can do this easily with a pivot table. See attached.
You will have to right-click the table and choose Refresh if you change the source data.
Attached Files
File Type: xlsx msoforums38364Material order TOPCRET-3.xlsx (44.0 KB, 10 views)
Reply With Quote