Formula that counts based on two variables by month and year

Hi Community,

I was able to find a formula here for counting how many times an employee was assigned to a task by month and date.

=COUNTIFS({Administration and Support Task List Range 3}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2021), {Administration and Support Task List Range 2}, "Employee")

I'd like to take the formula one step further. I have an LOE column with "Low", "Moderate", and "Difficult". I'd like to count the number of LOEs by an employee by month and year.

Thanks,

Doug

Find more posts tagged with

Accepted answers

Paul Newcome

You would enter a new range/criteria set in the same syntax as the existing sets.

=COUNTIFS({Administration and Support Task List Range 3}, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2021), {Administration and Support Task List Range 2}, "Employee", {Other Sheet LOE Column}, "Low")

All comments

Paul Newcome

You would enter a new range/criteria set in the same syntax as the existing sets.

Doug Shaddick

Thank you so much, Paul. It worked. Also, thanks for the previous formula from an earlier post you commented on.

Paul Newcome

Happy to help. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.