Hello, I have a number of COUNTIF functions that I need to work with different ranges that will be changed by a particular variable. In other words I am trying to write COUNTIF(C1:Cx,1) where x is the output of a specific cell. I am totally stumped on this. Thanks in advance for any help.
Hi and welcome to the forum
give this a try...
=COUNTIF(indirect("C1:C"&A1),1 where A1 contains x
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
It worked perfectly! Thank you for the help (and the greeting).
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)
another alternative avoiding indirect
=COUNTIF(C1:INDEX(C:C,A1),1)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks