Using labels in formulas

J

Joseph

Hi,

I have a small prob. I have a formula where the cell co-ordinates will have
to change based on the value available in another cell. For eg.,

If formula is

=COUNTIF(Sheet1!$W$1:$W$500,B7)

I want the number 500 to be picked from another cell which contains the
exact number or rows.

How can I achieve this?

Thanks in advance.

- Joseph
 
B

Bob Phillips

=COUNTIF(INDIRECT("Sheet1!$W$1:$W$"&M1),B7)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
J

Joseph

Thanks ...It worked!!!


Bob Phillips said:
=COUNTIF(INDIRECT("Sheet1!$W$1:$W$"&M1),B7)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
Click to expand...
 
S

Stan Brown

Wed, 22 Aug 2007 02:46:00 -0700 from Joseph
I have a small prob. I have a formula where the cell co-ordinates will have
to change based on the value available in another cell.
Click to expand...

See the INDIRECT function in Help.
 
Top