10000 cell (combined) reference limit



I'm getting the "10000 cell (combined) reference limit" in a grid file and cannot overcome it. My situation:

  • I have 5 master files with approx 14,000 lines of data
  • using =count to simply pull the number of lines in each file and summing those for a total using a single range in one column in each of the 5 files

That works fine until I try pulling in more metrics doing the following:

  • I do =countifs to find out how many lines are in "complete" status by looking in a status column for each file...then I get the limit issue.

How else can I extract my data from 65k lines to get the metrics I need for my team?

Thank you for any help on this issue.