I have a .csv file that I import into a sheet. Another sheet includes array
formulas that get the data for each store. One week the rows of data my
encompass A2:A538, the next week the range might be A2:A1040. An example of
one of the formulas follows; my formula ranges don't seem to adjust if the
range gets longer. I'm not sure this makes sense or not, but the $538 should
be $1040. Does the formula work as it should and the range does not change,
and if so how do I get around this problem? Thanks as always for any help
with this.

{=SUM(IF(A!$C$2:$C$538=PAC!$A7,IF(A!$A$2:$A$538=10 ,A!$B$2:$B$538,0),0))}