Remember Me?

#1
November 3rd 04, 07:10 AM
 JK Posts: n/a
variable range countif

I am wondering of there is a way to allow the range in countif to vary. I am
trying to make an analysis template that the user can specify the range
without having to go into the cell and re-specify it in the coutif funciton.
Is this possible? Or am I barking up the wrong tree?
Thanks.
-JK

#2
November 3rd 04, 07:21 AM

JK Wrote:
I am wondering of there is a way to allow the range in countif to vary.
I am
trying to make an analysis template that the user can specify the
range
without having to go into the cell and re-specify it in the coutif
funciton.
Is this possible? Or am I barking up the wrong tree?
Thanks.
-JK

Care to elaborate what you would want to have?

--
------------------------------------------------------------------------

#3
November 3rd 04, 07:47 AM
 Biff Posts: n/a

Hi!

Assume you want to count a variable range in column A.
Assume the range starts in A1 and your users can specify
the end of the range by entering a value in a cell, say
E1. In E1 you enter 10. The countif range will be A1:A10.

=COUNTIF(INDIRECT("A1:A"&E1),"whatever")

You can specify both the starting cell of the range and
the end of the range. D1 = 5, E1 = 10. The countif range
would be A5:A10:

=COUNTIF(INDIRECT("A"&D1&":A"&E1),"whatever")

Biff

-----Original Message-----
I am wondering of there is a way to allow the range in

countif to vary. I am
trying to make an analysis template that the user can

specify the range
without having to go into the cell and re-specify it in

the coutif funciton.
Is this possible? Or am I barking up the wrong tree?
Thanks.
-JK
.

#4
November 3rd 04, 07:50 AM
 Arvi Laanemets Posts: n/a

Hi

=COUNTIF(INDIRECT(A1),ValueToCount)
where cell A1 contains the reference string - like "X1:X100"

--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)

"JK" wrote in message
...
I am wondering of there is a way to allow the range in countif to vary. I

am
trying to make an analysis template that the user can specify the range
without having to go into the cell and re-specify it in the coutif

funciton.
Is this possible? Or am I barking up the wrong tree?
Thanks.
-JK

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Michael Sharpe Excel Discussion (Misc queries) 3 September 5th 12 01:33 PM Pat Walsh Excel Discussion (Misc queries) 5 January 21st 05 02:57 PM bryan New Users to Excel 2 January 19th 05 08:49 AM Pat Excel Discussion (Misc queries) 7 January 16th 05 09:52 PM Spencer Hutton Excel Discussion (Misc queries) 1 December 14th 04 10:15 PM

All times are GMT +1. The time now is 05:46 AM.