Hi there,
What I am trying to do is: if cell AA8 is x OR if cell AA11:AA49 are C,
please calculate as follow, but unfortunately, Excel doesn't pick up the
formular when I enter the cell range AA11:AA49.
However, when I try to put only one cell (AA11), the formular works just fine.

And the thing is I also tried a dummy test that I basically use the same
type of formular (but less complex calculation at the end), the formular also
works fine.

I wonder what went wrong? Doesn't Excel pick the original formular because
it is AA, or because the cell range (AA11:AA49) related to something else in
the sheet that might cause this complication/error?

Neon520

"daddylonglegs" wrote:

Hello Neon520,

I don't think you can enter that formula in a range. Perhaps you can explain
in words what you are trying to do


"Neon520" wrote:

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