Count if by date

@Paul Newcome Hey Paul, I'm working on further automating the tracking sheet you've helped me with. My goal is to tally a task completion by date from our plant managers progress sheet, currently I'm just counting and manually adding it to the column. Here are some screen shots

This sheet is filled out at the facility:

I would tally up when there's a date and fill out below

by the date specifically, is there a way to tally up and have the # of frames completed column automatically filled out from another sheet?

Find more posts tagged with

Accepted answers

Paul Newcome

Try this...

=COUNTIFS({Trenton Walter's Sheet Range 1}, @cell = Date@row)

All comments

Paul Newcome

Yes! But I would need to know your exact criteria for tallying. Are you just counting matching dates from a single specific column, or do you need to match on additional criteria?

Sean Murphy

Only specific dates, it's a very simple sheet, whenever the date cell is filled out, the task is completed. For example on the 1st screen shot, you'll see 3/23 on 5 different rows, then on the 2nd screen shot, on 3/23 you see the number 5.

This is my effort at doing it on my own =COUNTIFS({Trenton Walter's sheet Range 1}, ISDATE(Date25))

Paul Newcome

Try this...

=COUNTIFS({Trenton Walter's Sheet Range 1}, @cell = Date@row)

Sean Murphy

perfect, Thanks, Paul! I'm starting to understand the @cell function a little better

Paul Newcome

Happy to help! 👍️

The @cell reference basically tells the formula to look across the specified range and evaluate on a cell by cell basis.

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.