Grand Total Formula Query

[The_Snook]

Afternoon all,

There is no doubt a simple solution to this query that is evading me?!?! Basically I have a large amount of data broken down into separate groups with each having its own sub-total and grand total at the bottom. What I would like to know is is there a quick way to calculate the calculate the grand total at the bottom?

Thanks,

Snook

[XOR LX]

Hi.

=SUM(E2:E18)/2

Regards

[AlKey]

Here is another way:

Select all cells in range E2:E20, press and hold ALT key and press equal sign key.

[The_Snook]

Funnily enough that solution popped into my head as I was creating the thread but I thought i'd ask anyway to see if there were any alternative suggestions?

Cheers XOR LX, great minds!

Cheers for the shortcut tip AlKey it's one I use on a regular basis.

[AlKey]

You're welcome. Please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).