Sum for sub total and grand total

[slamet Harto]

Hi there

please help me on how to create vba code to sum for subtotal and grand total. the following data is actually generate from access query.

please find the attached for your reference

thanks for assistance

[Bob Phillips]

What is the data like to start with?