Dynamically sum a column

Hello,

I have a data from Column G to AV.
I would like to dynamically SUM column G based on the total rows count.
I want the result to be display in the last available row of Column G.

for example if the total count of column g is from G2:G99, i want the result to be display in G100 using the below formula:

=IF(SUM(G2:TOTAL COUNT OF ROW OF COLUMN G)=0,"",SUM(G2:TOTAL COUNT OF ROW OF COLUMN G))

Thanks in advance gurus!