PLEASE HELP this is about sorting cells

[ezteze]

i basically need to know how to get the total vendor amount to move at least one of the vendors multiple name. for example if i sort by date the same name vendors won't be grouped which i don't mind all i need is for example if i sort the date you can see the vendor orly city sports wear has 4 invoices and next to the last invoice amount is the total of all the invoices together so after sorting the date how can i get that total vendor amount to stick to at least one of the lines of that vendor name like basically make it attached and also the 13,502.35 is generated from a formula =SUM(D8:D11) so some how the formula will need to change some how and follow the amounts to the cells they go to after sorting the date or wtvr

[/URL][/IMG]

 

[Sahak]

Hi Ezteze,

Let say your data is in range A1:E1000, & column headings are in row 1 (A1-Date, B1- Vendor, C1-Invoice #, E1-Total Vendor Amount)
In Cell E1 enter this formula & copy down

 =SUMIF($B$2:$B$1000,B2,$D$2:$D$1000)

The “Bad” thing is (if you think this is bad) that same amount will be repeated for same vendor.