how can i get rid of #DIV/0! error

[Imran Azam]

his guys

i have the below formula which pics up the average day from a different sheet

IF(AND(MONTH(MAX('Days'!$Q:$Q))=5,YEAR(MAX('Days'!$Q:$Q))=2019),AVERAGEIFS('Days'!$S:$S,'Average Lead Days'!$E:$E,$D17,'Days'!$R:$R,"Qualified"),"-")

however when there is no data it comes back with a #DIV/0! error.

can i ad an if Error function to exclude this?

if so how?

thank you

 

[RoryA]

Just wrap the AVERAGEIFS part in it:

IF(AND(MONTH(MAX('Days'!$Q:$Q))=5,YEAR(MAX('Days'!$Q:$Q))=2019),IFERROR(AVERAGEIFS('Days'!$S:$S,'Average Lead Days'!$E:$E,$D17,'Days'!$R:$R,"Qualified"),""),"-")

 

[Imran Azam]

Thanks