I'm new to excel, I'm using the excel for dummies book. I'm working on a employee absence log.
I have 13 sheets, January thru December and a Total sheet. The 12 month sheets list the employee names in the columns a2 thru a21, then the dates are in rows b thru af. I want to use 1=absent, 2=late, 3=approved day off. I need a running total in the "Total "sheet. I think I need to use countif like this:
=countif[May:June:July:August:September:October:November:December!2b,2af"1")
=countif[May:June:July:August:September:October:November:December!2b,2af"2")
=countif[May:June:July:August:September:October:November:December!2b,2af"3")
It's not working and I must be missing something basic here. Can anyone point me in the right direction? I have attached the book. Thank you in advance for your time.
Bookmarks