Using SUMIFS across monthly worksheets

MrByte

Board Regular
Joined
Feb 9, 2007
Messages
167
Office Version
  1. 365
I have a summary page with people's names and I am summing up their sales from a given month (worksheet Jan, Feb, Mar, etc.). In those months there are one or more sales recorded in a row. But for some reason starting in the month of May and only on a few select people it no longer gives a sum of their sales. My formula on the Summary worksheet is: =SUMIFS(Jan!$E:$E,Jan!$G:$G,Summary!$A21) the E column is the amount I am summing. The G column is the name of the salesperson. And $A21 is the name I am summing on.

On the summary page, I have across the top as a column header Jan Feb Mar Apr ... and on the left-most column is the salesperson's name. Obviously, in the formula where Jan!$E:$E I change the Jan to represent the monthly worksheet, I am calling on. I have checked each formula and double-checked and even deleted and started over. I get the same result always starting with May it does not give me a sum on 3 of the salespeople.

So the question is, is there a better solution to this summary across monthly worksheets? Or is there some sort of glitch?
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Never mind it was my own error. I started thinking maybe the names in the list aren't the same each month. My bad.
 
Upvote 0

Forum statistics

Threads
1,223,888
Messages
6,175,213
Members
452,618
Latest member
Tam84

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top