Help with summation of different rows in 1 column

bassemjohn1

New Member
Joined
Jun 26, 2020
Messages
16
Office Version
2016
Platform
Windows
If you can do not keep any space between the vendors, just make a database sheetwith the following columns

SupCodecurrencySup NameINV No.INV DateInvoAmountOPay AmountODiff

the difference column, cells should have inv amt-paid amt.

Now at the end of this table say in column Z, make a list of supplier name ( If needed make the column Sup name to be data validated for list from this table ) so say in cell Z2 you have hertz and cell Z3 you have the entry oriental trading co, for the column containing supplier name you will be able to select these names, increase selection as much as you want .

In Column AA 2 put this formula =SUMIF(F:F,Z2,G:G) In this change F to the column name of your supplier name, and change G to the column name of your difference THEN YOU WILL GET THE TOTAL DIFFERENCE AMOUNT FOR EACH VENDOR
Not only that in Column AB2 put this formula =SUMIF(F:F,Z2,G:G) In this change F to the column name of your supplier name, and change G to the column name of your Inv. amt, THEN YOU WILL GET THE TOTAL INVOICE AMOUNT FOR EACH VENDOR
that's awesome way to do it !! but sadly I have to stick to 1 sheet according to their policy.
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,100,033
Messages
5,472,105
Members
406,804
Latest member
xbinsx

This Week's Hot Topics

Top