Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 3rd 04, 07:10 AM
JK
 
Posts: n/a
Default 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   Report Post  
Old November 3rd 04, 07:21 AM
Aladin Akyurek
 
Posts: n/a
Default


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?


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=274791

  #3   Report Post  
Old November 3rd 04, 07:47 AM
Biff
 
Posts: n/a
Default

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   Report Post  
Old November 3rd 04, 07:50 AM
Arvi Laanemets
 
Posts: n/a
Default

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Passing a range name as an argument to the Index Function Michael Sharpe Excel Discussion (Misc queries) 3 September 5th 12 01:33 PM
Creating an EXCEL COUNTIF formula for a range of values Pat Walsh Excel Discussion (Misc queries) 5 January 21st 05 02:57 PM
ClearContents method on a passed range bryan New Users to Excel 2 January 19th 05 08:49 AM
Defined range difficulty Pat Excel Discussion (Misc queries) 7 January 16th 05 09:52 PM
named range refers to: in a chart 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.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017