I need to count up all the machines that are less than 181 days old and older than 149 days. I can do this with sumifs, but not countifs. The sumifs formula I used that worked is below. I just need a count and not a sum.
=SUMIFS(April!$O$2:$O$1080,April!$B$2:$B$1080,Sheet1!A3,April!$O$2:$O$1080,">149",April!$O$2:$O$1080,"<181")
=SUMIFS(April!$O$2:$O$1080,April!$B$2:$B$1080,Sheet1!A3,April!$O$2:$O$1080,">149",April!$O$2:$O$1080,"<181")