COUNTIF
Hi,
I need to count the number of FALSE values returned in another worksheet
based on 'and' function in that column. I am using the following function:
=COUNTIF('Main Entry Sheet'!A26:A463,"'Main Entry Sheet'!AN26:AN463=FALSE")
but I get a 0 value returned as "=and........" is the true value of the
cells rather than the returned "TRUE/FALSE"
Please help
|