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