Forum Discussion

Ding080's avatar
Ding080
Copper Contributor
Jul 09, 2022

averageifs when there is no input

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

Formulas and Functions

2 Replies

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Jul 09, 2022

    Ding080 

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

     

     

Resources