I am using the following formula to track employee?s attendance occurrences, plus a few other items.
=IF(A15="","",IF(B15>$D$2,"N/A",IF(COUNTIFS('Data Entry'!$B$3:$B$99989,A15,'Data Entry'!$E$3:$E$99989,$D$1,'Data Entry'!$C$3:$C$99989,"Perfect Redeemed"),"PERFECT REDEEMED",IF(COUNTIFS('Data Entry'!$B$3:$B$99987,$A15,'Data Entry'!$E$3:$E$99987,$D$1),"PERFECT USED",IF(COUNTIFS('Data Entry'!$B$3:$B$1048576,A15,'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,A15,'Data Entry'!$A$3:$A$1048576,">="&$D$2,'Data Entry'!$A$3:$A$1048576,"<="&$D$3))))))
The first part of the formula is counting occurrences that the employee?s name shows up on the data entry worksheet.
=IF(A15="","",IF(B15>$D$2,"N/A",IF(COUNTIFS('Data Entry'!$B$3:$B$99989,A15,
What I am looking to do, is ignore/don?t count if the corresponding column ?Data Entry?!$C$3:$C$100000 contains the value of ?Other (See Comments)? or ?Positive Entry?.
The results would count all other instances where that employee name showed up when those values were not in column C.
This is pretty complicated, I had assistance making the original formula on here. Attached is a sample file.
I appreciate any help on this one.
Thank you,
Nick
Bookmarks