What is wrong with my Formula? I want to do a countifs to count by deal stage within a date range.

I am counting all of my deals in "Lease Negotiation" in the year 2023.

=COUNTIFS({Master Pipeline Tracker Range 1, "Lease Negotiating", >=DATE(2023, 1, 1), {Master Pipeline Tracker Range 3}, <=DATE(2023, 12, 31))

Please let me know what I am missing here.

Find more posts tagged with

Accepted answers

All comments

Your first problem is that Master Pipeline Tracker Range 1 doesn't have the } at the end of it. Your second problem is the DATE(2023, 1, 1) is where another range to evaluate is supposed to be.

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.