Countif Formula with Criteria

I am counting "On-Time" in another sheet and want to add additional criteria. So countif column Proof Delivery Status is "On-time" and column Alterations is NOT checked.

Current formula

=COUNTIFS({Premedia Completed Proof Delivery Status}, "On-time")

Shouldn't this formula work

=COUNTIFS({Premedia Completed Proof Delivery Status}, "On-time", {Premedia Completed Alteration}, 0)

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Yes. That should be working. Are you getting the wrong number or an error?

SmeyerEnpointe

Wrong number, but I believe I figured it out. I had to reconfigure the status column. Thank you for verifying it was correct.

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.