certificates
Board Regular
 Joined
 Apr 20, 2009
 Messages
 141
 Office Version

 2013
If I have this for a total of twelve monthly sheets
=IF(L67/22.5,SUM('September 2020:October 2019'!M67),"Error")
Currently, there isn't anything in any of the M67 cells and the function shows Error in the cell. If there were any sales at £22.50 the formula shows the correct answer.
Putting a £0.00 in the monthly M67 cells makes no difference, yet the two formulas L67/22.5 and SUM('September 2020:October 2019'!M67 both give £0.00 as a result.
How can I adjust this so that the result is £0.00 as it should be.
=IF(L67/22.5,SUM('September 2020:October 2019'!M67),"Error")
Currently, there isn't anything in any of the M67 cells and the function shows Error in the cell. If there were any sales at £22.50 the formula shows the correct answer.
Putting a £0.00 in the monthly M67 cells makes no difference, yet the two formulas L67/22.5 and SUM('September 2020:October 2019'!M67 both give £0.00 as a result.
How can I adjust this so that the result is £0.00 as it should be.