COUNTIFS to count all rows in another sheet where Status is Accepted

System

This discussion was created from comments split from: COUNTIFS with Multiple Criteria.

lrosenfeld

Hello! I am having a very similar challenge and have tried about 18 variations of this formula following the context here, the notes in the toolkit, etc. I am trying to capture the number of new hires that have been hired to a certain department from our Recruiting Tracking Sheet.

My Current formula is this. I want to understand all the new hires that were hired to our Operations team with the "Offer Letter Status" of accepted:

=COUNTIFS([{FY26 Offers & Benchmarking Practice}], "Operations", {FY26 Offers & Benchmarking Updated}, "Accepted")

Any help is much appreciated!

Soumitra Bhowmick

As long as {FY26 Offers & Benchmarking Practice} ,{FY26 Offers & Benchmarking Updated} are of same number of rows and starts from same row, it should work.

One more thing that seems off is use of [ in the formula. When you are referring to range from another sheet, [ is not needed, keeping the range name in { } is enough. Try the below and see if that helps


=COUNTIFS({FY26 Offers & Benchmarking Practice}, "Operations", {FY26 Offers & Benchmarking Updated}, "Accepted")