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?
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?