Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

For example:

 A      B      

7926    3     FROM     =COUNTIF(AQ$7926:AQ7970,"=0")
7926    3     FROM     =COUNTIF(AQ$7926:AQ7971,"=0")
7926    3     FROM     =COUNTIF(AQ$7926:AQ7972,"=0")
7926    3     FROM     =COUNTIF(AQ$7926:AQ7973,"=0")
7974    148   FROM     =COUNTIF(AQ$7926:AQ7974,"=0")
7974    148   FROM     =COUNTIF(AQ$7926:AQ7975,"=0")
7974    148   FROM     =COUNTIF(AQ$7926:AQ7976,"=0")

How do I change the starting row of a range based on a cell value on A?

share|improve this question
I don't know what your second edit was for, but please check your formatting. There's a preview – use it! And don't write in caps lock. – slhck Nov 3 '11 at 15:54
Ups, Caps lock is my mistake, sorry for that. Thanks slhck – hermanov Nov 3 '11 at 16:20

Not sure I've understood well your question but are you looking for the INDIRECT formula?

If in cell A1, you add the value B1 and in cell B1 you have Got it.

The formula: =INDIRECT(A1) will return Got it

You can use it in your formula.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.