I knew there was a limit, but not how much

what were you putting in a single cell?

Oh, y'know, a >10,000 character formula, as y'do

.... Kit. Kit, wtf. XD

Listen!

I need the sheet to look at each of 12 columns across 5 tabs and look for one specific term to occur, then reference 12 other columns in those 5 tabs and see if either of two other terms occurs, then reference 1 other column in each of those 5 tabs and see if one specific term occurs, and if ALL of those are true, count it!

Sometimes you just have to satisfy upper administration by crunching admissions data across 7 cycles to see how many of /each/ Idaho institution had applicants who received degrees from that Idaho institution, AND interviewed, and you don't wanna do it yourself, so you write a really Big formula!

...okay, no, that's fair!