adding a sum formula in the last cell of a column named "fees" in multiple spreadsheets

[mehdi hannechi]

Hey guys,
need your help please
so after splitting a masterfile into different ws, i need to detect a specific column named " fees"( it's location may differ from one sheet to another), go to the last non blank cell in that colmun (i.e D15), then add a sum function in cell D16 summing all entries from D2 to D15.

Thanks in advance !

 

[JGordon11]

maybe

if .value>10 then .offset(1,0) = "word"