software

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

=COUNTIF(INDIRECT(B40amp;quot;:quot;amp;B56),yourValue)

HTH
--
AP

quot;Matthieu de Witquot; lt;Matthieu de gt; a écrit dans
le message de ...
gt; I want to define a range using values in two cells. Let's say cell B40
gt; contains information about the cell at which the range should start (it
says
gt; for example: cell B101) and cell B56 contains information about the cell
at
gt; which the range should stop (it says for example: cell B256). Now I want
to
gt; count specific values within this range. Can I define the range using the
gt; information in cell B40 and cell B56 with a formula? I hope anyone can
help
gt; me, it would save me a lot of work.
gt;
gt; Matthieu
Hi there Ardus Petrus, this works perfect for me. Thank you very much!!

Matthieu

quot;Ardus Petusquot; wrote:

gt; =COUNTIF(INDIRECT(B40amp;quot;:quot;amp;B56),yourValue)
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;Matthieu de Witquot; lt;Matthieu de gt; a écrit dans
gt; le message de ...
gt; gt; I want to define a range using values in two cells. Let's say cell B40
gt; gt; contains information about the cell at which the range should start (it
gt; says
gt; gt; for example: cell B101) and cell B56 contains information about the cell
gt; at
gt; gt; which the range should stop (it says for example: cell B256). Now I want
gt; to
gt; gt; count specific values within this range. Can I define the range using the
gt; gt; information in cell B40 and cell B56 with a formula? I hope anyone can
gt; help
gt; gt; me, it would save me a lot of work.
gt; gt;
gt; gt; Matthieu
gt;
gt;
gt;