How do I sum totals against supplier?

[Chris Mitchell]

I download my bank statements into an Excel spreadsheet, one work
sheet per month, one spreadsheet per year, and want to be able to
ascertain how much I'm spending with various suppliers as follows

Supplier Amount
S1 £20
S2 £15
S3 £2.50
S1 £5
S2 £30

Total spent with S1 £25
Total spent with S2 £45
Total spent with S3 £2.50

What formulae can I use that will enable me to total all of the
amounts in one column against a supplier in an adjacent column?

How could this basic formulae be modified to cope with variable length
of contents, i.e. one month may have 25 entries, the next could have
30 or more.

I suspect some form of LookUp would be required, but this is not one
of my strong suites.

 

[mcg]

I download my bank statements into an Excel spreadsheet, one work
sheet per month, one spreadsheet per year, and want to be able to
ascertain how much I'm spending with various suppliers as follows

Supplier Amount
S1 £20
S2 £15
S3 £2.50
S1 £5
S2 £30

Total spent with S1 £25
Total spent with S2 £45
Total spent with S3 £2.50

What formulae can I use that will enable me to total all of the
amounts in one column against a supplier in an adjacent column?

How could this basic formulae be modified to cope with variable length
of contents, i.e. one month may have 25 entries, the next could have
30 or more.

I suspect some form of LookUp would be required, but this is not one
of my strong suites.

tru to use pivot table that is dedicated to that kind of calculations
to create dynamic range visit
http://www.contextures.com/xlNames01.html#Dynamic
mcg