I am using the formula =SUM('7-10'!F12+'8-10'!J12-'8-10'!F12)
This is to work out average daily sales in 24 hours. But if no sale is recorded for 7-10!f12 but sales are recorded for 8-10!f12 it shows as - (what ever sales there were).
I would like this to show 0 unless there is data in all fields in the formula.
Is this possible?