How do I define a range using values in cells?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to define a range using values in two cells. Let's say cell B40
contains information about the cell at which the range should start (it says
for example: cell B101) and cell B56 contains information about the cell at
which the range should stop (it says for example: cell B256). Now I want to
count specific values within this range. Can I define the range using the
information in cell B40 and cell B56 with a formula? I hope anyone can help
me, it would save me a lot of work.

Matthieu
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I have a cell value define a dynamic named range? 15
Logical Test 5
Set non-continuous PrintArea via Function / Name 0
Conditionally format a cell using a list of data defined in a rang 2
VBA set thick borders around non empty cells in range 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Macro to "find" the next empty cell in a range 2
Constructing Range Name calls with Concatenate 4

Back
Top