A couple countif formulas

Shannon Scarbrough

I have a couple formula questions:

1. I want to count the number of employees hired from 1/1/21-until today (and have it update to be today in real time moving forward). So far I have =COUNTIFS({GB Users Source Sheet Range 1}, @cell = "Active", {GB Users Source Sheet Range 5}, "Full Time", {GB Users Source Sheet Range 4},
2. I want to count the number of rows with a status of "In Budget" and with info coming from another column which have "GBA" selected.

Thank you!!

Paul Newcome

Try this for the second one...

=COUNTIFS({Status Range}, @cell = "In Budget", {Dropdown Column Range}, @cell = "GBA")

Paul Newcome

For the first one you are going to use the Date Range along with an AND function.

=COUNTIFS(........................................., {Date Range}, AND(@cell >= DATE(2021, 01, 01), @cell <= TODAY()))

For the second... Is the column with "GBA" a multi-select dropdown?

Shannon Scarbrough

Hi Paul,

GBA is a single select column. Thanks!

Paul Newcome

Try this for the second one...

=COUNTIFS({Status Range}, @cell = "In Budget", {Dropdown Column Range}, @cell = "GBA")