averageifs when there is no input



G'day all, 

How would i use the following formula, but not return a #div/0! error when there is not yet any input for the specific date range?

thank you


F51 and G62 are cell references to dates within a 12 month financial year period

2 Replies




Does it work with the help of the IFERROR function?



thank you, works perfectly.