countif
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
|