Sum data (or subtotal) by ID number in Excel

[jtjones]

Hi all,

Is there a way to sum amounts by duplicate ID numbers in another column?

Say I have:

ID    Amount
1        $5
1        $3
1        $2
2        $5
3        $4
3        $3

How do I subtotal by ID number?

TIA

 

[KenWright]

Take a look at the SUMIF function

or at Data / Subtotals

or at Pivot tables

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

 

[bluedragon2]

or SUMPRODUCT function

=SUMPRODUCT((A1:A100=1)*(B1:B100))

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...