Attendance Tracker

Hi,

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.

Try the following formula in cell B3 on your Attendance Tracker sheet.

=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")

Then copy and paste.

Norman

Hello Norman,

Thank you so much for the formula, its working fine . Have great day......