#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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.
|
#3
|
||||
|
||||
A pivot table can do this very easily. See the pivot at cell J7 attached.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |