Please elaborate; if the account is a unique identifier, why limit the
ranges in your countif statement? E.g., why not count the total number of
times that account shows up in the entire column (B:B)?
Thanks,
Keith

"WildlyHarry" wrote in message
...
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.