SUMIFS with wildcard (*)

Hello, I am trying to use the sumifs formula for summing values in one column based on the first two letters in another column. This formula is not working

=SUMIFS([Total Invoiced]:[Total Invoiced], [Google Location ID]:[Google Location ID], "CA*")

I have tried exchanging the criteria column at the beginning as well, and it doesn't work. It brings back 0, and not the actual sum.

Any idea?

Find more posts tagged with

Formulas

Sheet Summary

Accepted answers

All comments

Paul Newcome

Try this:

=SUMIFS([Total Invoiced]:[Total Invoiced], [Google Location ID]:[Google Location ID], LEFT(@cell, 2) = "CA")

francisca.bacho

Amazing!!! curious to why the other one is not working, but this solves my frustration. Thanks!!

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.