Summing up the balances for individual companies

  • Thread starter Thread starter dolphinv4
  • Start date Start date
D

dolphinv4

Hi,

I have a table that looks like this:

Company Invoice Amt
ABC Ltd 100.00
XYZ Ltd 200.00
DEF Ltd 500.00
ABC Ltd 150.00
DEF Ltd 200.00

I need to have another table to automatically lookup and
sum up the amounts belonging to individual companies, ie,

Company Total Invoice Amt
ABC Ltd 250.00
DEF Ltd 700.00
XYZ Ltd 200.00

How do I do it? Tried using the fn vlookup but can't seem
to do it...

Thanks!
Val
 
Hi

Try using the function "SUMIF"....

=SUMIF($A$1:$A$1000,C1,$B$1:$B$1000)

Where $A$1:$A$1000 is the range of cells with the company
names, C1 = the company name, and $B$1:$B$1000 = the
values to sum if the company equals C1.

Hope this helps.
Paddy
 
Back
Top