L

#### Legacy 116183

##### Guest

=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.