I have an attendance sheet for the children's program I am in charge of at Church. I created the countif formual to count how many children showed up on any given night and also how many times during the year that anyone particular child show up to the program. The formula I used was as follows:
=countif(A4:A34, "X") for each night (at the bottom of each column) &
=countif(A4:P4, "X") for the yearly count (at the end of each row)
everything was working fine until I got to the second half of the year and I come to Column X, now my countif formula has stopped working, it no longer counts the "X" for attendance. Any thoughts. I have attached the attendance file for anyone who can help me.
Thank you.
Bookmarks