You can get the range with

OFFSET(A1,,,COUNTA(A:A))

something like

=COUNTIF(OFFSET(A1,,,COUNTA(A:A)),weeknum)

but why not just use the whole of the coilumn

=COUNTIF(A:A,weeknum)

(BTW not really sure how you will test, so my examples may need to be
adapted to your real situation).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"WorkerB5 " wrote in message
...
I'm using the COUNTIF function to work out how many, but the range needs
determining somehow.

WB5


---
Message posted from http://www.ExcelForum.com/