Sumifs formula application questions

I'd like to apply for sumifs formula in sheet, but seems the function cannot capture the correct sum amount, details as following:

Expectation：sum up total service fee from legal entity: 137 with quarter: Q1, and I list the sumifs function as below：

The result from the above formula comes up as 55527.49 while the correct result should be: 132903.29 (amount details can be found in enclosed file)

Reference details:

FY26 Payment Tracking List – CN -Service Fee

FY26 Payment Tracking List – CN – LE

FY26 Payment Tracking List – CN – Quarter

Wondering what's wrong with my formula

Looking forward to reply!!

FY26 Payment Tracking List - CN - Ask Smartsheet.xlsx

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Instead of the criteria

"137"

try this criteria:

@cell + "" = "137"

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.