Try it this way:

=COUNTIF('Jan 05'!C4:AG4,"x")+COUNTIF('Feb 05'!C4:AD4,"x")+
COUNTIF('Mar 05'!C4:AG4,"x")+COUNTIF('Apr 05'!C4:AF4, "x")

If you had to do it for all 12 months this would result in a pretty long
formula. There's a shorter alternative but it requires that all the ranges
are the same.

Biff

"Amanda" wrote in message
...
I am trying to count the number of "x" in a row in multiple worksheets.
This
is the formula I have been trying to use
=COUNTIF('Jan 05'!C4:AG4+'Feb 05'!C4:AD4+'Mar 05'!C4:AG4+'Apr 05'!C4:AF4,
"x")

Why isn't it working. Please help.

Thanks
Amanda