trouble with formulas

[wdwisser]

Okay, I updated it to use the 2-500 (e.g. =SUMIF(D$2:D$500,BJ4,J$2:J$500)/2000) in the formula and the number of rows that contain data are through 575 and still the same thing, the formula doesn't execute until I click on it and press Enter. Hmmm... very peculiar. With this change some of the formulas now contain a value of zero since the data is only available through to row 500, but that is to be expected.

[wdwisser]

Does anyone have any insight on why this occurring? Shouldn't the formulas work once you open up the spreadsheet or am I missing something.

Thanks for your input.