COUNTIFS with Multiple Criteria

I am trying to count the overtime "Yes" in a given week by matching the Department "Tech Unit D"

The formula I am working with always brings back Zero: I've tried with and without and. Any help would be greatly apricated, I'm a newbie to this :)

=COUNTIFS([Week Ending]:[Week Ending], >=TODAY(-5), [Overtime?]:[Overtime?], "Yes", Department:Department, "Tech Non-Rep")

I was able to count to OT in a week by using this formula but can't get it to work when adding in the actual department

=COUNTIFS([Week Ending]:[Week Ending], >=TODAY(-5), [Overtime?]:[Overtime?], "Yes")

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Make sure that when you are entering the "department" criteria you are spelling it exactly the same. How is the Department column being populated? You may need to double click into it as if you are going to edit it to see if there are any extra spaces tucked in somewhere. Extra spaces are not visible when just looking at a cell but are stored on the back-end.

TLaGrant

Double checked the departments and no spaces. Any other thoughts?

Paul Newcome

What about the overtime column?

And how exactly is the Week Ending column set up?

TLaGrant

No in the form the fill out it is a radial button but I did double check. There are no spaces anywhere.

Paul Newcome

And how exactly is the Week Ending column set up?

TLaGrant

It's set to date

Paul Newcome

How is it being populated?

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.