suppose you have col A supplier code and col B amount.
Use this formula =Subtotal(9,B1:B100). Then filter the supplier code.


On Nov 26, 7:37*pm, Rachie1987
wrote:
I dont know how to explain this or what words i am supposed to use but
basically i have a list of thousands of supplier codes and their invoice
values. For example

60ACE3562 * * * -2,467.50
60ACE3562 * * * -197.75
60ACO0202 * * * -626.28
60ACO0202 * * * -626.28
60ACO0202 * * * -405.38
60ACO0285 * * * -9,170.88
60ACO0285 * * * -9,170.88
60ACO0285 * * * -2,326.50
60ACO0285 * * * -834.25
60ACO0285 * * * -346.63
60ACO0285 * * * 9,170.88
60ACT1350 * * * -8,214.43
60ACTIONFI * * *-3,330.40
60ACTIONFI * * *-3,258.38
60ACTIONFI * * *-3,213.33
60ACTIONFI * * *-3,132.48

And i need to get a list for say 60ACTIONFI the total amount of all values.
So a sum of 3330.40 + 3258.38 + 3213.33 + 3132.48.

I need this so i can filter by supplier code to see who we have spent the
most with. At the minute i am having to filter the list by supplier name and
then take the sum and write it down manually - i no there must be a quicker
way!! Possibly an IF statement or SUMIF but i am not too clever with these...
Thank you