Where am I going wrong in this SUMIF formula?

Here is my formula: =SUMIF({Shell Projects - High Level Tracker CP}, Wholesaler@row, {Shell Projects - High Level Tracker Owner})

I'm trying to say, if the "Owner" on another sheet equals the Wholesaler on the row on my sheet, then sum the CP on that other sheet.

The formula isn't throwing any errors, but is return an answer of "0" which is not correct.

Find more posts tagged with

Formulas

Accepted answers

KT_H

Hi Kelly,

You have the sum range and the criterion range flipped, try this.

=SUMIF({Shell Projects - High Level Tracker Owner}, Wholesaler@row, {Shell Projects - High Level Tracker CP} )

All comments

KT_H

Hi Kelly,

You have the sum range and the criterion range flipped, try this.

=SUMIF({Shell Projects - High Level Tracker Owner}, Wholesaler@row, {Shell Projects - High Level Tracker CP} )

Kelly Gabel

Thank you! I thought I had tried that combination but I must not have!

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.