Liverpool1959
New Member
- Joined
- Mar 16, 2015
- Messages
- 45
Hello
This should be easy for you guys!!
Column A - Row 1 will be employee name. Rows 2 and down will be days of the calendar. I want to enter a "1" if he worked and a "0" if he didn't work. At the bottom will be the Total. What I need is a formula to calculate how many days the employee has worked in the last 24. So when I enter todays number (either 1 or 0) it still only counts the bottom 24 cells with values in it.
Thanks
This should be easy for you guys!!
Column A - Row 1 will be employee name. Rows 2 and down will be days of the calendar. I want to enter a "1" if he worked and a "0" if he didn't work. At the bottom will be the Total. What I need is a formula to calculate how many days the employee has worked in the last 24. So when I enter todays number (either 1 or 0) it still only counts the bottom 24 cells with values in it.
Thanks