The cell range is not updating correctly to reflect the last row in the data
sheet that is being refreshed. 5878 is the correct number of rows and 5824
is not. I can find and replace in my formulas to correct the problem, but it
does it each time the data is refreshed. Any suggestions as to why?


=(SUMPRODUCT((Expense!$B$2:$B$5878=$C$2)*(Expense! $C$2:$C$5878=$C$3)*(Expense!$W$2:$W$5824=$A6)*(Exp ense!$M$2:$M$5878)))