I have attached a sample tracker - where i have 2 tabs one is attendance tracker and another one is production tracker.
Now i am looking out for a formula which counts attendance based on there production numbers for that respective day.
Here is what is am looking:
If an employee has done production more than "0" than his attendance should reflect as "Present".
If an employee has done production less than or equal to "0", than his attendance should reflect as "Absent".
Can anyone please help me out to solve this.
Re: Attendance Tracker
Try the following formula in cell B3 on your Attendance Tracker sheet.
Then copy and paste.
=IF(SUMPRODUCT(--('Production Tracker'!$A$3:$A$17=B$1)*('Production Tracker'!$B$3:$B$17=$A3)*('Production Tracker'!$C$3:$C$17))>0,"Present","Absent")
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1