How to count on another sheet how many terminated employees per month?

Elisa Hogan

Hello,

I am trying to use the following formula in another sheet to count how many employees were terminated on the system per month:

=COUNTIFS({Status}, @cell = "terminated", Month@row, {Turnover per month 2021 Range 4}, Year@row, {Turnover per month 2021 Range 2})

What am I doing wrong?

MCorbin

Assuming the sheet you included in the screen shot is your raw data sheet, right?

Try this:

=COUNTIFS({Status}, Status@row, {Turnover Month}, [Turnover Month]@row, {Turnover Year}, [Turnover Year]@row)

Note: When you're setting up a cross-sheet formula, you can use the "Sheet Reference Name" box to re-name your range, which makes it a LOT easier to troubleshoot your formula when you come back to it later: