I have the first row with auto sum function to calculate the (Total Invoice Value) which is in column "H".

There are hundreds of invoices with details. So, when I want to filter any one invoice, say, Invoice No. 1550 (Which has 10 rows with 10 item details), the Total Invoice Value is showing the sum of whole column not of just these 10 rows.

How to resolve this issue?