Click and drag error

I’m using the following to calculate the growth and loss of my savings since the start of the year as a percentage:  =SUM(B6B2)/B2 where B6 is current value and B2 the original

Problem is when I click and drag it I get this in the next cell: =SUM(B7B3)/B3 when it actually needs to be: =SUM(B7B2)/B2

Any help appreciated 🙂

By: Dom Lowe

Leave a Reply

Your email address will not be published. Required fields are marked *