IFSUMS using word and numbers

Hello,

I am building a matrix sheet to pull data from a source sheet and trying to use an IFSUMS formula, but have received various outcomes

#UNPAREBLE =SUMIFS(({Evt Support Level},[Event Support Levels]@row , {Event Month}, May1)+sumif({Event Year}, 2025))

#INCORRECT ARGUMENT SET - =SUMIFS({Evt Support Level}, [Event Support Levels]@row , {Event Month}, May1, {Event Year}, "2025")

Returns 0 =SUMIFS({Evt Support Level}, {Evt Support Level}, [Event Support Levels]@row , {Event Month}, May1, {Event Year}, "2025")

Here is my source sheet

All three columns are dropdowns. Would that have something to do with the formula not working?

Find more posts tagged with

SumIfs

if formula

Accepted answers

All comments

Jgorsich

SUMIFS Function | Smartsheet Learning Center

SUMIFS(range, criterion_range1, criterion1, [criterion_range2, criterion2, ...])

Your first two attempts are missing arguments (specifically, the range to sum). The third attempt you put the 2025 in quotes, this turns it into a string (a combination of letters and numbers) instead of a number (which is what you have). You also put "May1" for month WITHOUT quotes - this needs to be in quotes and needs to align with values you actually have in the column (so, probably "May"). Remove the quotes from the third attempt around 2025 and correct the month criterion and you will likely be okay.

Aimee Colton

I still get #Unparable with this version=SUMIFS({Evt Support Level}, {Evt Support Level}, [Event Support Levels]@row , {Event Month},"May", {Event Year}, 2025))

May1 was @row, but I also tried the above with May1 and no quotes around 2025, and neither has worked

Paul Newcome

Are you able to provide a screenshot of the formula open in the sheet as if you are about to edit it?

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.