Error Message Help

[slhope23]

Hi,

I currently have this formula:

=+IF(AVERAGEIFS('Rin Data Sell'!$E:$E,'Rin Data Sell'!$A:$A,$A112,'Rin Data Sell'!$H:$H,H$1)=0," ",AVERAGEIFS('Rin Data Sell'!$E:$E,'Rin Data Sell'!$A:$A,$A112,'Rin Data Sell'!$H:$H,H$1))

However it is populating an error message on cells that there is no information in Rin Data Sell. How do I put in an IFError than '' into this formula?

 

[DataBlake]

How do I put in an IFError than '' into this formula?

=iferror(+IF(AVERAGEIFS('Rin Data Sell'!$E:$E,'Rin Data Sell'!$A:$A,$A112,'Rin  Data Sell'!$H:$H,H$1)=0," ",AVERAGEIFS('Rin Data Sell'!$E:$E,'Rin Data  Sell'!$A:$A,$A112,'Rin Data Sell'!$H:$H,H$1))),"Error")

 

[AlanY]

try

=iferror(your formula here,"")