Help with cell totals

  • Thread starter Thread starter blackie
  • Start date Start date
B

blackie

Hi all,

My problem is that I have two rows, one contains the manufacturers
name, and the other the amount that manufacturer supplies. What I need
to do is get the sum of the amount supplies for each manufacturer.
Example:

Company 1 8
Company 2 5
Company 2 7
Company 1 2

Totals:

Company 1 10
Company 2 12
 
One way via SUMIF ..

Assuming this list is in Sheet1,
in cols A and B, row1 down
Company 1 8
Company 2 5
Company 2 7
Company 1 2
Click to expand...

and this is in Sheet2
(List of companies in A1 down)
Company 1 10
Company 2 12
Click to expand...

Put in B1: =SUMIF(Sheet1!A:A,TRIM(A1),Sheet1!B:B)
Copy down

Col B will return the figs shown
 
Blackie,

Sort on Company name and use SubTotals (Data > SubTotals).

HTH,
Nikos
 
Back
Top