I basically am working on a attendance roster. that is going to cover a 20
day period. I need a formula that will automatically count when someone
missed, so it does not have to be done manually.

basically I have 20 cells going across and it will be filled in with one of 3
things. 4.0 meaning they were their for their full shift, 0.0 meaning they
were absent, and blank meaning that day has not happened yest.

I want the formula to find every time the cell has 0.0 as the answer and
count by 1 when it does. so it will say this person has missed this many days.


--
Message posted via http://www.officekb.com