Jul 09 2022 02:44 AM - edited Jul 09 2022 09:52 PM
SOLVED
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
=AVERAGEIFS(GAIN_LOSS,DATE_OF_ENTRY,">="&DATE(YEAR(F51),MONTH(F51),1),DATE_OF_ENTRY,"<="&G62)
F51 and G62 are cell references to dates within a 12 month financial year period
Jul 09 2022 02:49 AM
=IFERROR( AVERAGEIFS(GAIN_LOSS,DATE_OF_ENTRY,">="&DATE(YEAR(F51),MONTH(F51),1),DATE_OF_ENTRY,"<="&G62) ,"")
Does it work with the help of the IFERROR function?