I type in the following formula and keep getting the error message that it is
missing a parenthesis. No error message when using the "pop up" window to
assist with the formula but when I hit "enter" I get the parenthesis
notification. However, I have added them everywhere I can think of it is
still getting rejected. BTW, what I am trying to tell Excel is "If there is
a 0 in one cell AND an X in another cell, count it."

=COUNTIF(AND(Attendance!D6=0,Violations!C6="X")

What am I mising?