My Count If formula doesn't work with a < in the field i need to count

I want to count the number of rows which have the <50sqm in the Implementation stage column, i don't get an error with the below formula but this also doesn't give me the correct number, it just returns a 0.

=COUNTIFS([IMPLEMENTATION STAGE]:[IMPLEMENTATION STAGE], "<50sqm", [BUILD START DATE]:[BUILD START DATE], <=DATE(2020, 12, 31), [EVENT TYPE]:[EVENT TYPE], <>"Digital", [EVENT STATUS]:[EVENT STATUS], <>"Cancelled")

this formula works with every other status i have in the same column apart from the <100sqm option.

Any ideas how i can fix this without changing the data to say "under 50 sqm"

Find more posts tagged with

Formulas

Accepted answers

All comments

David Tutwiler

You could use CONTAINS to search for the 50sqm part. Something like:

CONTAINS("50sqm", @cell)

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