Thread: Generate list from column A and sum amount from column B
View Single Post
 
Old 07-17-2019, 05:39 PM
baes10 baes10 is offline Windows 7 64bit Office 2007
Advanced Beginner
  
Join Date: Dec 2017
Posts: 33
baes10 is on a distinguished road
Default Generate list from column A and sum amount from column B
Hello, could you help create a formula to generate a list of all items from column C and calculate a sum from column F for each item from column C? I'd like the formula to pick up all variations of text in column C which will contain room numbers. Then sum all associated room numbers together.
Hope this make sense.
Thank you.

example
104 - $50.00
105 - $25.00
109 - $15.00
Attached Images
File Type: jpg 1.JPG (146.2 KB, 17 views)
Attached Files
File Type: xlsx Guest & Employee Meal List.xlsx (25.8 KB, 7 views)
Reply With Quote