Hi,
This is my 1st post to the site, so apologies if this question has already been asked.
I have a column in a spreadsheet (AA) where values will appear depending on results in other cells.
My question is, is there a formula to SUM the first 4 numbers in the column, bearing in mind that the cells above it contain a formula? (in this instance the SUM of AA70-73).
For reference, next week cell AA69 will contain a value (depending on results elsewhere in the workbook), so in that instance I would need the formula to SUM the values in AA69-72.
I hope this all makes sense!?
Cheers,
Chris
This is my 1st post to the site, so apologies if this question has already been asked.
I have a column in a spreadsheet (AA) where values will appear depending on results in other cells.
My question is, is there a formula to SUM the first 4 numbers in the column, bearing in mind that the cells above it contain a formula? (in this instance the SUM of AA70-73).
For reference, next week cell AA69 will contain a value (depending on results elsewhere in the workbook), so in that instance I would need the formula to SUM the values in AA69-72.
I hope this all makes sense!?
Cheers,
Chris