How to read from excel where a text is in the middle of the excel sheet and how to add the sum of the values under it

Hi All,

I am trying to check the total of debit and credit in the excel columns. But the columns and rows are not standardized.

image

I need to find this columns debit and credit text are available and add up all values under Debit , add up all values in credit and compare.

The values are unlimited and should not count the last row under credit and debit which is a total.

Any suggestions would really help