View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matthieu de Wit
 
Posts: n/a
Default How do I define a range using values in cells?

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