"IF" formula using dates and check boxes

Courtney Caswell

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

Mike Wilday

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

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

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