If Error statement

[datadummy]

Is it possible to combine an iferror statement and a countifs statement into one?

Here is my current countifs: =COUNTIFS(AACH!C:C,">8/31/2019",AACH!C:C,"<10/1/2019",AACH!F:F,"Y")/COUNTIFS(AACH!C:C,">8/31/2019",AACH!C:C,"<10/1/2019")

My current statement is returning #DIV/0! which is correct because there is no data that meets the parameters set, but what I would like to do is in this event have it return "NA" if there is no data that meets the parameters. Is this possible?

 

[Eric W]

Try:

=IFERROR(COUNTIFS(AACH!C:C,">8/31/2019",AACH!C:C,"<10/1/2019",AACH!F:F,"Y")/COUNTIFS(AACH!C:C,">8/31/2019",AACH!C:C,"<10/1/2019"),"NA")

 

[datadummy]

That did it, thanks!!

 

[Eric W]

Happy to help!