Trouble with SumIF Formula

Mkaur

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.

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.