View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rachie1987 Rachie1987 is offline
external usenet poster
 
Posts: 10
Default HOW CAN I ADD UP ALL VALUES WITH THE SAME REFERENCE..

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