Macro to clear row containing Total and sum Col B and Col C

I have written code to first clear the last row where "Total" is in Col A as well as the values in the same row as "Total" in Col B & C

I cannot get this to clear the last row where total is as well the values in the same row as "Total" in Col B & C


Secondly I need to total Col B & C. My code is only totalling Col B

See code below

 Sub TotalGLcodes()
Sheets(6).Select
Finalrow = Range("A65536").End(xlUp).Row
Range("A" & Finalrow + 1).Resize(2, 2).ClearContents
Finalrow = Range("A65536").End(xlUp).Row + 2
Range("A" & Finalrow + 3).Value = "Total Value"
Range("B" & Finalrow + 3).Resize(, 1).Formula = "=sum(B1:B" & Finalrow & ")"
End Sub

It would be appreciated if someone can kindly assist me