G
Guest
I need a function for an employee attendance card. I want it to look at a
cell that would have the code of either v=vacation, s=sick, h=holiday and so
on and then add up the number of hours that is either in the same cell or a
different cell nearby for the corisponding letter. So that we can track how
many days people have left. Can you even do this? If so how would you
suggest going about this?
cell that would have the code of either v=vacation, s=sick, h=holiday and so
on and then add up the number of hours that is either in the same cell or a
different cell nearby for the corisponding letter. So that we can track how
many days people have left. Can you even do this? If so how would you
suggest going about this?
12,"",E8:E12) =SUMIF(D8