SUMIF Doesn't Work When I Reference Another Sheet

tlclark

When I use this formula it works

=SUMIF([Target Month]:[Target Month], "February", [# of Devices]:[# of Devices])

But when I put it in another sheet and reference it I get an unparseable error. Any ideas why?

=SUMIF({Branch Refresh Schedule}[Target Month]:[Target Month], "February", [# of Devices]:[# of Devices])

Find more posts tagged with

Accepted answers

Summer

@tlclark I've mocked it up on my end and this formula works for me:

=SUMIF({Branch Refresh Schedule| Target Month}, Month@row, {Branch Refresh Schedule | # of Devices})

Range: {Branch Refresh Schedule| Target Month} the group of cells to evaluate

Criterion: Month@row the condition that defines which numbers to add. In this case it refers to the month column on the Formula sheet and takes the place of "February". Can easily be replaced back with "February"

Sum Range: {Branch Refresh Schedule | # of Devices} the group of cells to add together. Could be replaced with the [# of Devices]:[# of Devices] range if it's on the same sheet as your formula.

Formula Sheet (Formula is in the # of Devices Column)

Branch Refresh Schedule

All comments

Summer

Hi @tlclark

My original answer was incorrect.

For the first part of the formula where you are selecting the range, utilize the "Reference Another Sheet" option and select the range on the source sheet that includes the Target Month.

So your updated formula would read something like this

=SUMIF({Branch Refresh Schedule Range 1}, "February", [# of Devices]:[# of Devices])

tlclark

Hi @Summer

I did try that as well and it didn't work. Not sure what I missed.

Summer

@tlclark I've mocked it up on my end and this formula works for me:

=SUMIF({Branch Refresh Schedule| Target Month}, Month@row, {Branch Refresh Schedule | # of Devices})

Range: {Branch Refresh Schedule| Target Month} the group of cells to evaluate

Sum Range: {Branch Refresh Schedule | # of Devices} the group of cells to add together. Could be replaced with the [# of Devices]:[# of Devices] range if it's on the same sheet as your formula.

Formula Sheet (Formula is in the # of Devices Column)

Branch Refresh Schedule

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.