Hi there,
I have a question about the "cell reference" in Excel.
I wonder why Excel doesn't pick up the cell reference that I enter in my
fomula
(=IF(OR(AA8="X",AA11:AA49="C"),"",IF(AA11:AA49="C" ,"",$A$50-COUNTIF(AA11:AA49,"X")-COUNTIF(AA11:AA49,"N")-COUNTIF(AA11:AA49,"C")-COUNTIF(AA11:AA49,"A")-COUNTIF(AA11:AA49,"AE")-COUNTIF(AA11:AA49,"B")-COUNTIF(AA11:AA49,"BE")-COUNTIF(AA11:AA49,"LTL")))

Excel doesn't pick up (OR(AA8="X",AA11:AA49="C") this part at all. I think
the rest of the formular is fine. But when I try (ORAA8="X",AA11="C"), the
formular works fine.

Excel gives me (#VALUE!) error when I enter it as a cell range (AA11:AA49),
instead of one cell (AA11)

Does anyone have any idea of how to fix this, or what is wrong with my
formular?
Any info/clue are appreciated!!!!!

Neon520