Thread: Generate list from column A and sum amount from column B
View Single Post
 
Old 07-18-2019, 12:21 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2016
Expert
  
Join Date: Apr 2014
Posts: 866
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
A pivot table can do this very easily. See the pivot at cell J7 attached.
Attached Files
File Type: xlsx msofficeforums42987Guest & Employee Meal List.xlsx (26.5 KB, 6 views)
Reply With Quote