Why are my sumif values different on my "sheet summary" than they are on my separate sheet?

I have a sumif formula in my "sheet summary" that is giving me a correct value when summing my values on that sheet. My formula is:

=SUMIF([Project Status]:[Project Status], "Active /WON", [Project $ Value]:[Project $ Value])

When I use the sumif formula on a separate sheet referencing the same data I am getting a much less value. My formula on this separate sheet is:

=SUMIF({Project Status}, "Active /WON", {Project $ Value})

Find more posts tagged with

Formulas

Accepted answers

All comments

Mike Wilday

I don't see any reason why you would get different results. Unless you didn't select the entire column as your cross sheet reference and only selected a portion of the column.

Max Corbin

Hi Mike - Fortunately when I refreshed it, my values were the same. Thank you kindly!

Mike Wilday

Dang refresh!!!

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.