|
|
#1
07-17-2019, 05:39 PM
|
|||
|
|||
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 
|
|
|
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 |
Windows 7 64bit 
Office 2007
Threaded Mode