Jump to content
  • The above Banner is a Sponsored Banner.

    Upgrade to Premium Membership to remove this Banner & All Google Ads. For full list of Premium Member benefits Click HERE.

  • Join The Silver Forum

    The Silver Forum is one of the largest and best loved silver and gold precious metals forums in the world, established since 2014. Join today for FREE! Browse the sponsor's topics (hidden to guests) for special deals and offers, check out the bargains in the members trade section and join in with our community reacting and commenting on topic posts. If you have any questions whatsoever about precious metals collecting and investing please join and start a topic and we will be here to help with our knowledge :) happy stacking/collecting. 21,000+ forum members and 1 million+ forum posts. For the latest up to date stats please see the stats in the right sidebar when browsing from desktop. Sign up for FREE to view the forum with reduced ads. 

Stack Tracker


Recommended Posts

Top man thank you! I use a Windows Excel sheet every day but it's been set up by my company not me. I use a Mac at home.

Progress is a myth. Democracy is a sham. Dumbing down is real.
Throw your mobile 'phone in the bin, it will free you!
Turn your TV off, cancel your licence.

Link to comment
Share on other sites

15 hours ago, Orpster said:

You can add in new rows and the calculations will pick them up, but always add to the middle of a section not the first or last row.

If you're prepared to compromise on visual style, then include a blank row between each section, and set up your SUM(...) formulae to include that blank line. Then you can safely insert new rows at the top/bottom of each group, not just in the middle, and the formulae will update correctly.

But I don't know how to make your fancy thick/thin borders work if you do this - I never bother with borders because I have so many blank lines everywhere that separate things out 🙂

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Cookies & terms of service

We have placed cookies on your device to help make this website better. By continuing to use this site you consent to the use of cookies and to our Privacy Policy & Terms of Use