I understand the perception but disagree. I do not believe that using the worksheetfunction in VBA and inserting a formula are 2 TOTALLY different things. You have enough successful posts of code to know that there is always more than 1 way to get the same thing done. I was merely stating that using the worksheet function can eliminate the need for the worksheet to recalculate. Some people may not understand how necessary this is unless they are working with very large sets of data, such as 20,000+ rows. I myself would never run a regular countif formula on a large set of data because it just takes too long, and then if I have used an autofilter the worksheet would need to recalculate after I unfiltered or deleted any rows. To each their own but again I dont find these totally different.