Hello,
I need assistance adding this COUNTIFS:
=IF(COUNTIFS('Data Entry'!$B$3:$B$100000,$A5,'Data Entry'!$E$3:$E$100000,$D$1),"PERFECT USED")
Before the first COUNTIFS in the below:
=IF(B5>$D$2,"X",IF(COUNTIFS('Data Entry'!$B$3:$B$1048576,A5,'Data Entry'!$A$3:$A$1048576,">="&$D$2,'Data Entry'!$A$3:$A$1048576,"<="&$D$3)=0,"PERFECT ATTENDANCE",COUNTIFS('Data Entry'!$B$3:$B$1048576,A5,'Data Entry'!$A$3:$A$1048576,">="&$D$2,'Data Entry'!$A$3:$A$1048576,"<="&$D$3)))
I am trying to insert it here, but I keep getting errors:
=IF(B5>$D$2,"X",---Inserting Here---IF(COUNTIFS('Data Entry'!$B$3:$B$1048576,A5,'Data Entry'!$A$3:$A$1048576,">="&$D$2,'Data Entry'!$A$3:$A$1048576,"<="&$D$3)=0,"PERFECT ATTENDANCE",COUNTIFS('Data Entry'!$B$3:$B$1048576,A5,'Data Entry'!$A$3:$A$1048576,">="&$D$2,'Data Entry'!$A$3:$A$1048576,"<="&$D$3)))
I appreciate any help.
Thank you,
Nick
Bookmarks