Sorry for all the dumb questions :( I'm still getting used to excel.
I need to go down a column and sum some cells before it. However depending on the column this may change.
I tried using the Sum function but that requires the values to be set.
In a column the sum cells will be the same... Ie go down G sum values from A-F, however the next column may be J and it needs to sum values from H & I.