Countifs criteria difficulty

Logan Hubbard

I'm trying to count the number of units installed and removed between two dates, along with narrowing it down to a specific machine and product type created with the units. The installation date and removal date are both logged into separate columns within a different sheet. The hope is to make something similar to a search feature in that the criteria can be changed and the formula will update results rather than using filters on the original data sheet. Where am I going wrong?

=COUNTIFS({Machine #}, =[3]@row, {Product Type}, =[2]@row, ({Date Installed}, >= ([4]2), {Date Removed}, <= ([5]2)))

bisaacs

Hey @Logan Hubbard,

The last two criteria sets in the formula have a weird number of parenthesis around them, would removing them so there's only the COUNTIFS parenthesis help?

bisaacs

Hey @Logan Hubbard,

The last two criteria sets in the formula have a weird number of parenthesis around them, would removing them so there's only the COUNTIFS parenthesis help?

Logan Hubbard

https://community.smartsheet.com/discussion/comment/437662#Comment_437662

That must've been it! I was experimenting with using AND and isolating some of the reference cells to make sure my commas were in the right spots, those must have been leftover from that. Thanks!