This might be a formula or a macro/VBA - I have a feeling it will be VBA.
I have 5 columns in a sheet; B, E, H, K and N. These cells will be changed every so often. They will contain numbers.
So for example cells B3 could contain number 20 and then a few weeks later be changed to number 40. The running total would be 60.
I would like a formula/macro/VBA code that will add the figures to the overall total every time the figure in B, E, H, K or N.
So for example B3 is 20 then it is changed to 40, the total would be 60.
Then cell E3 is changed to 30, so the running total is 90.
Then B3 is changed again to 60, so the running total is 150 and so on.
I am happy for this to be one code or formula that calculates all cells, or for it to be 5 different codes; one for each cell. This will be over 10,000 rows, so it will need to either work on all rows in the sheet, or allow copying to all rows.
An example is attached and I would appreciate any help.
Thanks in advance.
Bookmarks