Advanced formula's

Hi Charnel

Thanks for your question. To make sure I understand the problem can I check what happens when you put a sum function in column 13 that sums the values and the cells with formulas? Usually Excel's sum function will ignore the contents of cells with no value or non relevant text - if the contents of these cells changes to contain values that could be summed Excel automatically includes them in the result.

Let me know how you get on and we'll try to help further.

Kind regards,
Andrew