Hi,
at the bottom or top of your sheets enter this formula

=subtotal(9,C1:c100)

then filter your information by name

"Timo" wrote:

Dear all,

I want to use subtotals for Name, to sum the amounts. I would get a total
line for Name1 with value 300... However I would also like to see the ID in
the total line. How do I do that? Thanks in advance.

ID Name amount
1234 Name1 100
1234 Name1 200
2000 Name2 125
2000 Name2 200
[...]