SUM of lines where there is a common number in a column

[miro2021]

Hello

I have a spreadsheet containing a list of invoices. Some invoices have several lines and each line is on a new row of the spreadsheet. Some invoices have only one line.
Each line has a column with the £net amount of that line and another column with the tax amount.

I am trying to find total line amount (sum of the net amount of each line for that invoice) and total tax amount for that invoice.

Please see below to explain better - I am trying to generate the blue columns (I entered the values manually to illustrate what I am trying to achieve)
I've also attached the sample spreadsheet

I would really appreciate assistance on this


Capture.JPG

[Pete_UK]

You can use this formula in cell K2:

=IF($J2="","",SUMIF($B:$B,$J2,H:H))

Copy into L2, then copy those two formulae down, as required.

Hope this helps.

Pete

[Syrkrasi]

Or here is another formula

For TxtTaxableAmt (Total for invoice): =IF(J2="","",SUMPRODUCT(--($B$2:$B$34=B2),$H$2:$H$34))
For TxtTaxAmt (Total for invoice): =IF(J2="","",SUMPRODUCT(--($B$2:$B$34=B2),$I$2:$I$34))

[miro2021]

Thank you for your help - this worked fine for me.

[Pete_UK]

Glad to hear it - thanks for the rep.

Pete