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

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")

Find more posts tagged with

Formulas

Countif

Accepted answers

Nic Larsen

Try something like this:

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

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.