Need a formula

[Darrell_Sarrasin via OfficeKB.com]

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.

 

[WLMPilot]

Try the following, changing the cell references to meet your needs.

=COUNTIF(A1:I1,"=0.0")

 

[Darrell_Sarrasin via OfficeKB.com]

hehe I was trying to make it way to complicated. thanks

Try the following, changing the cell references to meet your needs.

=COUNTIF(A1:I1,"=0.0")

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

[quoted text clipped - 6 lines]

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.