Sum of Current Column

[thebrucekt]

Hi All,

I would like to also show the current day's late and present count of all employees. Say for instance, January 8 is the current date, we have 3 employees who are Present, so Column D (this will always show the current day count) should show as 3. Same concept with Column E. Columns D and E should only count the current days total of present and late employees. It should just show it in D2 and E2 rows.

[leelnich]

Hi @thebrucekt- This in D2:

Please Login or Register  to view this content.

...and in E2:

Please Login or Register  to view this content.

Obviously, you can expand the ranges to cover full pay periods and/or more employees.

[thebrucekt]

Hi @leelnich,

Amazing! It worked as expected! You're AWESOME!

Thank you very much for guiding me...