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

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?

Find more posts tagged with

Formulas

Accepted answers

All comments

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:

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.