Please tell use WHAT you need rather than HOW you are doing it because I
think there could be another way.
Give as a sample (fake , if necessary) data set

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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.