SUMIF and CONTAIN referencing another sheet

ProductDan

Hi Guys,

Have got lost in this one, and I think we might be close to cracking it.

I am trying to Sum the values from one column referencing a name from separate column, a little like a sales sheet.

The complexity is that I am trying to reference another sheet and I keep getting #Unpareseable

=SUMIFS({1.Groups WIP Range 1}, {1.Groups WIP Range 4}, CONTAINS("Dan Mitchell", @Cell))

This is the above formulae that I am using

Can you see anything I am missing here?

Thanks

Dan

Find more posts tagged with

Accepted answers

Paul Newcome

@cell should be all lower case.

All comments

Paul Newcome

@cell should be all lower case.

ProductDan

@Paul Newcome

Cant believe it was that simple! How annoying haha (Thanks Paul)

Have got a 0 now, but there should be a much higher value.

Any ideas on this one?

Paul Newcome

What exactly are you selecting for each of your ranges, and can you provide screenshots of the source data?

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.