Trouble with SumIF Formula

Hello,

I am utilizing the sumif formula to showcase that where the total hr in a month (Sum of M5) a Manager is working in that month. Below is the formula that is working when i use the sheet summary within the same sheet.

=SUMIF([Manager]:[Manager], "A", [Sum of M5]:[Sum of M5])

However I am trying to pull this data in a another sheet where I am trying to create the Dashboard, below is the formula I am trying to use, but its not reflecting the correct data.

=SUMIFS({ImpOpportunities 3.21 Range 6}, {ImpOpportunities 3.21 Range 4}, "A")

Range 6 equals the Sum of M5 column and Range 4 is the Manager Column

I cant seem to figure out what i am missing.

Find more posts tagged with

Accepted answers

All comments

Nathan Slatton

Try using a summery on the sheet. If your formula is working on the grid you can do a summery that =(cell) and then put a metric on the dashboard.

Mkaur

I created the sheet summary within the actual sheet and i can only transfer the sheet data as a report i cant link the sheet summary data in another sheet.

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.