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

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

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

"Darrell_Sarrasin via OfficeKB.com" wrote:

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

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


WLMPilot wrote:
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.

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