Hello,

I am looking to add to the formula below.

If the results of the countifs equals 0, I want it to display the words "None" instead of 0.

COUNTIFS('Data Entry'!$B:$B,$A5,'Data Entry'!$A:$A,">="&$G$2,'Data Entry'!$A:$A,"<="&$G$3,'Data Entry'!$C:$C,"<>TEST1",'Data Entry'!$C:$C,"<>TEST2")

I appreciate any help.

Thank you,
Nick