COUNTIF, Dates, and Variables

[Any Onmouse]

I have a sheet with rows for each data entry point (we
will call them tickets). Each ticket has an open and
close date.

I want to create a chart showing the cumulative open and
close counts for each week. I started by creating a
seperate sheet with dates across the top and then a row
for opens and a row for closed. The formula in each cell
as along the lines of
=COUNTIF(range of cells in sheet two with open
dates, ">date for the week")
(an actual copy...=COUNTIF(Sheet2!K2:K397,">Sheet1!B2")

My problem - the criteria does not seem to like having a
variable. Is what I am doing roughly right? Can some
one suggest an option?

thanks

 

[Mike Lee]

Try:

=COUNTIF(Sheet2!K2:K397,">" & Sheet1!B2)

That should do it.

Mike