Another way ... non-volatile:

Enter start row in A1,
And end row in A2.

=COUNTIF(INDEX(Sheet2!C:C,A1):INDEX(Sheet2!C:C,A2) ,Sheet3!$D5)

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"carl" wrote in message
...
I use this function

=COUNTIF(Sheet2!C$324:C$344;Sheet3!$D5)

I am looking for a good way to vary the range C$324:C$344 based on a number
I input in anther cell.

Lets say in a1 I have the value 20. I would like the range to be
C$324:C$344.

If I change a1 to 50. I would like the range to be C$294:C$344.

Basicaly take the end of the range - C$344 - and subtract the number in a1.

Is this possible.

Thank you in advance.