I have a 600 row spreadsheet, and I'm using the following formula to sum items paid within a specific date range, column I is the amount, column L is the date paid:

=SUMIFS(I10:I600,L10:L600,">6/30/2012",I10:I600,"<7/1/2013")


I discovered that altough the formula works, it does not pull amounts above $41,000 ($41,820 to be exact). I can go into that record and change the amount to below $41,000 and the total will adjust and include that line. But when I change it back to an amount above $41,820, the total drops that line.....very weird.

I don't have this issue if I just sum column I, or if I use sumif for a specific date that includes one of the lines above $41,820. It only happens with SUMIFS.

Is there an amount limitation when using SUMIFS formula?