Trying to count today only

Ken Hogan

I have an employee sign-in sheet where I want to show todays stats or metrics.

This is how I count

=COUNTIF({Bergmeyer Employee Sign-In Range 2}, ="WFH")

I wanted to do something like

=COUNTIF({Bergmeyer Employee Sign-In Range 2}, ="WFH", Today())

but it doesn't work. I don''t know how I tell it the date is in a different range or column?

Paul Newcome

You would need to use a COUNTIFS (with the "S" on the end). Then you can specify multiple range/criteria sets.

=COUNTIFS({Bergmeyer Employee Sign-In Range 2}, ="WFH", {Date Column}, @cell = TODAY())

Paul Newcome

You would need to use a COUNTIFS (with the "S" on the end). Then you can specify multiple range/criteria sets.

=COUNTIFS({Bergmeyer Employee Sign-In Range 2}, ="WFH", {Date Column}, @cell = TODAY())