Hi all, I have a formula that looks at the cell value on one sheet and adds it to the previous value on the original sheet, my problem is this....where this formula appears it shows the last summed value so in this case from S6 down to Sxxx it will show the value £813 because this is the last value it added, in the formula below i would like it to state that if 'Account Entry'!S6 is zero then dont calculate S6+S5 just show zero! is this possible in a formula? =IF('Account Entry'!S6="","0",'Account Entry'!S6+S5)

Regards,
Simon