Grand total in same column

Hello it is possible to have grand total of amount in same column like I have group A to C who have grand total and I don't want to include group D and E because they have also grand total..is it possible?how can I do this on VBA?thanks in advance

You can use something like this
place it in Module

Please Login or Register  to view this content.

Then initialize in cell where you want to see result
for example A20=grandTotal(A1:C19)

Best Regards
MaczaQ