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

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

MrByte

Board Regular
Joined
Feb 9, 2007
Messages
167
Office Version
  1. 365
Never mind it was my own error. I started thinking maybe the names in the list aren't the same each month. My bad.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,477
Messages
5,831,900
Members
430,090
Latest member
bjonesh2o

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
Top