I have an extremely large file that I need to compare against another
extremely large file. I am using a countif function based on the criteria
"account #". My issue is that my file contains accounts from my 12 different
markets. I am using a match function now to provide me with the start cell
for each of my markets and adjusting my countif formula range accordingly.
Is there anyway to nest the match formula so that it automatically populates
my countif ranges. For example:

Market 1 starts on b1
Market 2 starts on b1000
Market 3 starts on b4000
=countif(match1:match2-1,"account")
=countif(match2:match3-1,"account")
and so on...

Thanks in advance for the help.