Garage_Doors
Originally the Swankers
You guys last time were great last times so i will ask another please.
If i want to add up the totals for a particular supplier in the list below, is there a formula i can use that will give me the total spend for any given one?
ie adds up all that i have spent with each.
I know i can do a simple addsum and click each line entry but there must be an easier way?
Medlock £34.75
Diesel £50.00
Brewers £12.23
B&Q £30.00
B&Q £66.65
Brewers £17.83
Wickes £3.39
Wickes £149.00
Diesel £50.00
B&Q £76.09
Halfords £11.24
B&Q £30.00
Homebase £4.99
B&Q £7.92
Screwfix £1.02
Halfords £11.64
Wickes £60.42
Diesel £50.00
G&S Ltd £21.09
Brewers £4.03
B&Q £42.29
If i want to add up the totals for a particular supplier in the list below, is there a formula i can use that will give me the total spend for any given one?
ie adds up all that i have spent with each.
I know i can do a simple addsum and click each line entry but there must be an easier way?
Medlock £34.75
Diesel £50.00
Brewers £12.23
B&Q £30.00
B&Q £66.65
Brewers £17.83
Wickes £3.39
Wickes £149.00
Diesel £50.00
B&Q £76.09
Halfords £11.24
B&Q £30.00
Homebase £4.99
B&Q £7.92
Screwfix £1.02
Halfords £11.64
Wickes £60.42
Diesel £50.00
G&S Ltd £21.09
Brewers £4.03
B&Q £42.29