Combine countifs with match for greater than or less than values

[mmcmillin]

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")

 

[mmcmillin]

Can someone help me? I can't find anything on this.

 

[Marcelo Branco]

Try

=COUNTIFS(April!$B$2:$B$1080,Sheet1!A3,April!$O$2:$O$1080,">149",April!$O$2:$O$1080,"<181")

M.

 

[mmcmillin]

Thank you!!!!

 

[LoochMaglike]

I need a formula that can search for a location number on two spreadsheets (there are over 6,000 locations on each spreadsheet), which may be on each spreadsheet multiple times, then confirm the next column (representing one of several elements at that location) there may be 3-4 of this same element at each location, then I need the formula to return a response based on matching that location and that element and pull in the 1st outcome for that element at that location, 2nd outcome for the second of the same type of element at that location, then 3rd etc, then move down spreadsheet to the next type of element and then to the next location and set of elements. Help?

Example

Store	element	last year's price		Store	element	This year's price
54662	137 sm	200		54667	137 sm	250
54662	137 sm	250		54667	137 sm	275
54667	137 sm	300		54667	137 sm	315
54667	137 sm	300		54667	137 sm	310
54677	137sm	500		54677	137sm	510
54677	137sm	450		54677	137sm	460
54453	85 sm	300		54677	85 sm	310
54356	85 sm	300		54677	85 sm	315
54677	12 sm	250		54677	12 sm	270
54677	24 sm	175		54677	24 sm	180
54677	32 sm	180		54677	32 sm	190
55766	137 sm	250		55442	85 sm	260
55766	137 sm	275		55442	85 sm	285
55766	137 sm	275		55442	70 sm	285
55766	55 sm	150		55442	12 sm	160
55766	75 sm	175		55442	24 sm	185
55766	85 sm	185		55442	55 sm	195
55766	85 sm	195		55442	55 sm	190
55766	137 sm	250		55442	40 sm	260
55442	85 sm	180		55766	137 sm	190
55442	85 sm	170		55766	137 sm	160
55442	70 sm	160		55766	137 sm	180
55442	12 sm	90		55766	55 sm	100
55442	24 sm	130		55766	75 sm	140
55442	55 sm	150		55766	85 sm	160
55442	55 sm	155		55766	85 sm	175
55442	40 sm	140		55766	137 sm	155

<colgroup><col><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>

<tbody>
</tbody>