I have in a column (C) data of Spend for various Regions (A) /Countries (B)
I have created a sum formula in C to sum spend for the region. Data is
sorted region wise and country wise

I want to create a grand summary total in one stroke at the end of the LAST
region, summing the spend of all countries and exlude the sum data in the
cells ,otherwise a double summing is resulted.