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

How do I define a range using values in cells?
 

=COUNTIF(INDIRECT(B40&":"&B56),yourValue)

HTH
--
AP

"Matthieu de Wit" <Matthieu de a écrit dans
le message de ...
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

How do I define a range using values in cells?
 

Hi there Ardus Petrus, this works perfect for me. Thank you very much!!

Matthieu

"Ardus Petus" wrote:

=COUNTIF(INDIRECT(B40&":"&B56),yourValue)

HTH
--
AP

"Matthieu de Wit" <Matthieu de a écrit dans
le message de ...
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