I am trying to get a unit count between a date range.

chaczef

I am trying to get a unit count between a date range. I have two difference columns from one sheet and two difference columns on my main sheet I am referencing. I keep getting unparseable. Is there a way to to get the number I want with using the countifs formula? Or should I be using a different formula?

This is the formula I am using:

=COUNTIFS({15-ImpDate}, >=[Start Date]@row, {15-ImpProdHr}:{15-ImpProdHr}, >"0") + COUNTIFS({15-ImpDate}, <=[End Date]@row, {15-ImpProdHr}:{15-ImpProdHr}, >"0")

Nic Larsen

Try something like this:

=COUNTIFS({15-ImpDate}, AND(@cell >=[Start Date]@row, @cell <=[End Date]@row), {15-ImpProdHr}, >0

Nic Larsen

Try something like this:

=COUNTIFS({15-ImpDate}, AND(@cell >=[Start Date]@row, @cell <=[End Date]@row), {15-ImpProdHr}, >0

chaczef

That worked perfectly! thank you!