SOLVED

COUNTIFS for a specific text within a yearly date range

Copper Contributor

Hello everyone,

 

I am having some issues trying to get my excel to pull data from a different tab to count the total of the "Unsats" within a yearly date range. I have attempted to change it from COUNT IFS to IF to A put receive errors each time. I have also gone through multiple posts and different sites, but the other formulas I have used did not work either. The "Unsats" are in column G and the Date ranges are in column B (formatted as D-MMM-YYYY) where they both start off on the 3rd row. Any help would be appreciated, thank you!

 

The current formulas I have attempted are:

=COUNTIFS(Inspections!G3:G550,"Unsat", Inspections!B3:B550, ">=1-Jan-2023", Inspections!B3:B550, "<=31-Dec-2023")

 

=COUNTIFS(Inspections!G3:G550,"Unsat", Inspections!B3:B550,">="&DATE(1-Jan-2023),Inspections!B3:B550,"<="&DATE(31-Dec-2023))

2 Replies
best response confirmed by Kevinnn912 (Copper Contributor)
Solution

You dates are wrongly inputted. Try-

=COUNTIFS(Inspections!G3:G550,"Unsat", Inspections!B3:B550, ">=" & DATE(2023,1,1), Inspections!B3:B550, "<=" & DATE(2023,12,31))

That worked! Thank you!!

1 best response

Accepted Solutions
best response confirmed by Kevinnn912 (Copper Contributor)
Solution

You dates are wrongly inputted. Try-

=COUNTIFS(Inspections!G3:G550,"Unsat", Inspections!B3:B550, ">=" & DATE(2023,1,1), Inspections!B3:B550, "<=" & DATE(2023,12,31))

View solution in original post