I would like for my formula to return N/A in column G when there is an N/A in column C. The following screenshot provides my current formula:`
=IFERROR(MINIFS(Hoofdtab!$AE$2:AE19883;Hoofdtab!$V$2:V19883;F6;Hoofdtab!$I$2:I19883;">="&$C$2;Hoofdtab!$I$2:I19883;"<="&$D$2;C6;"<>"&N/A);"N/A")
I am using excel 2019
If anyone has any idea about how I should change my formula I would be a very happy man.