Multiple conditions for counting

Super-basic question regarding COUNTIFS. I'm trying to return a value that shows me a count of projects from a certain year, for a certain client.

=COUNTIFS((Project Number:Project Number), Contains("2025", @cell ),(Client:Client), Contains("ADV", @cell ))

But this comes up as unparseable. Where am I going wrong?

Find more posts tagged with

Formulas

Accepted answers

All comments

heyjay

=COUNTIFS(
[Project Number]:[Project Number], CONTAINS(@cell , "2025"), 
Client:Client, CONTAINS(@cell , "ADV"))

Paul Newcome

Any column name that has a space, special character, and/or a number in it, you have to wrap the column name in square brackets.

[Column Name]:[Column Name]

[Column Name]@row

mcwalden

Thank you both so much. This is now both parseable and comprehensible!

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.