Excel 2003
I have a formula that counts all the "yes"s in a range of cells which it
does correctly. in the next cell I have the exact same formula counting the
"no"s in the same range of cells - it returnes "0" but there are two "no"s in
the range.
I have completely erased the formula and typed it in again, I have run
"evaluate" on it, I've checked the formatting of the cells... I can't get it
to count the "no"s. !!!!
I have three different ranges that I'm doing this for and I copied the
formula to count the no's and entered it into a different cell to count a
different range, and it counts the no's...
I'm stumped. Anyone have an idea?
thanks, Meenie