"IF" formula using dates and check boxes

I am looking to set up a count to see how many people are scheduled for an appointment verses how many have come in.

I have an appointment date column and a check box that is clicked when someone comes in. I want this to be a summary formula not a cell. Could someone help?

What I messed around with was =COUNTIF(Name:Name,AND(Date:Date>=TODAY(),Check:Check=0))

I also tried an =IF(AND(Date:Date>=TODAY(),Check:Check=0),Count(Name:Name))

Find more posts tagged with

Formulas

Accepted answers

Mike Wilday

To see the count for scheduled future events you would use...

=Countifs(Date:Date, >=Today())

All comments

Mike Wilday

It looks like you're trying to count how many were scheduled for TODAY and how many came in. Is that correct? If so, try this:

=COUNTIFS(Date:Date, Today(), Check:Check, 1)

Based on my sample only the two highlighted rows would be counted. You can see I am getting 2.

Courtney Caswell

@Mike Wilday Good Morning Mike,

I am also looking to count events in the future as well. Just not anything in the past.

Mike Wilday

To see the count for scheduled future events you would use...

=Countifs(Date:Date, >=Today())

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.