Hi,

I'm trying to calculate the total value of cells: A1:A5.

A1:A3 has a formula inputted into the cells and A4:A5 has manual values entered into the cells.

Is there a formula to only SUM the cells with manual values entered into them from range A1:A5. This is so if i update a cell with a formula inside it, It will update.

Example: If i update update cell A2 then the total value changes as this isn't a formula anymore.

Kind regards,

caf20012.