How to Count a Code in one Column when the Task is due Within a Time Period

Hi Community,

Looking for some assistance here I have a summary sheet where I am looking to perform some cost calculations. I want to pull the count of when cost code 1 is logged but only when the task happens before a date (Finish < a date) into the cell of another sheet

Here is my attempt: =COUNTIFS({LCM China Project Plan_example Range 0}@row < DATE(2023, 3, 1), 1, {LCM China Project Plan_example Range 1}, 1)

Find more posts tagged with

Accepted answers

All comments

Ryan Sides

Hmmm. If I understand what you're looking to do... try this...

=COUNTIFS({LCM China Project Plan_example Range 0}, < DATE(2023, 3, 1), {LCM China Project Plan_example Range 1}, 1)

Looks like you had too many pieces in there, but you were on the right track.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.