Hi!
Assume you enter in cells:
A1 = 5
B1 = 10
=COUNTIF(INDIRECT("N"&A1&":N"&B1),"Y")
Which translates to:
=COUNTIF(N5:N10,"Y")
Biff
---Original Message-----
I need to create a formula that references a range of
cells. The range is
supposed to be determined by what the user enters into
another cell. Can a
formula have a variable in it that will grab a number
from another cell?
For instance:
=COUNTIF(N[B18]:N[B18+B18],"Y")?
Where you see B18 the user has entered in a number, we
will say it was 5. I
need the function to reference the cells in the N column
from N5 (cell B18
has a 5 in it) to N10 (B18+B18 or 5+5).
I appreciate any help you all can give me. Thanks so
much in advance.
Brockettb
.
|