Maxing Out Cross Reference Sheet



I'm using an Index Match formula to pull info into a roll up sheet:

=SUMIF({AC 2020 Priority Hotels}, "Complete", {AC Jan ITR}) / COUNTIF({AC 2020 Priority Hotels}, "Complete")

However, I'm getting this error message:

The max is around 25K cells which I definitely don't have in my sheets. However, when I cross reference a sheet (AC 2020 Priority Hotels) and choose the column (AC Jan ITR), it's picking every single cell in that column....when I only actually have data in 150 cells.

So, my question is - I'm maxing out the cross sheet references because it's picking every cell in my 60 columns - so how can I just pick certain cells within column and not the entire column?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!