Automatic update to count values within a specific month

Lynn Collier

Hi, I currently use a countifs formula to count  the number of met criteria within a given  month. Data is entered monthly through a form.  What formula can I use to automatically update the month automatically?   The below formula works, but I have to manually enter the first and last day of the month in its respective column.

=COUNTIFS({Date}, >=[1st Month]1, {Date}, <=[Last Month]1, {Time Out Audit Range 3}, "met")

Paul Newcome

Try something like this...

=COUNTIFS({Time Out Audit Range 3}, "met", {Date}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(MONTH(@cell), 0) = = 2020))

Just update the 1 and the 2020 for whatever month and year you are wanting to count for.