Generate list from column A and sum amount from column B

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

07-18-2019, 12:21 PM

p45cal

Windows 10 Generate list from column A and sum amount from column B

Office 2016

Expert

Join Date: Apr 2014

Posts: 962

A pivot table can do this very easily. See the pivot at cell J7 attached.

Attached Files

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:33 PM.