Microsoft Office Forums Generate list from column A and sum amount from column B

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-17-2019, 05:39 PM
baes10 baes10 is offline Generate list from column A and sum amount from column B Windows 7 64bit Generate list from column A and sum amount from column B Office 2007
Advanced Beginner
Generate list from column A and sum amount from column B
 
Join Date: Dec 2017
Posts: 32
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, 13 views)
Attached Files
File Type: xlsx Guest & Employee Meal List.xlsx (25.8 KB, 3 views)
Reply With Quote
  #2  
Old 07-18-2019, 10:49 AM
baes10 baes10 is offline Generate list from column A and sum amount from column B Windows 7 64bit Generate list from column A and sum amount from column B Office 2007
Advanced Beginner
Generate list from column A and sum amount from column B
 
Join Date: Dec 2017
Posts: 32
baes10 is on a distinguished road
Default

Hi instead, could you help me create a lookup formula to search column "Resident room #" and return all values grouped together? Hope that makes sense.
Reply With Quote
  #3  
Old 07-18-2019, 12:21 PM
p45cal p45cal is offline Generate list from column A and sum amount from column B Windows 10 Generate list from column A and sum amount from column B Office 2016
Expert
 
Join Date: Apr 2014
Posts: 280
p45cal has a spectacular aura aboutp45cal has a spectacular aura aboutp45cal has a spectacular aura about
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, 2 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Generate list from column A and sum amount from column B How do you add values in a column when determining the lowest amount within multiple groups wheddingsjr Excel 5 09-07-2018 12:35 PM
Keep balance column empty if no amount entered baes10 Excel 3 08-14-2018 06:31 AM
Automatically generate formulas from just the row numbers (auto insert the column) knewman Excel 14 04-25-2017 11:54 PM
Generate list from column A and sum amount from column B If a cell equals amount in column B. lawnphysics Excel Programming 1 01-16-2016 07:51 PM
How can I temporarily break a 3 column format in order to type a single column paragraph William P Word 1 01-04-2015 06:40 PM


All times are GMT -7. The time now is 08:39 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft