Can I use the Countif function to count an unique entry in multiple worksheets?? I have two separate worksheets for the two fortnights of the month. One for the first fifteeen days and the other for the next fifteen days. I would like to count the number of entries matching a particluar criteria in both the sheets at the same time. All the conditions like the range, the criteria remain the same. The only thing that changes is the names of the worksheets. And I don't want to combine the worksheets in to one. Can I do it??? Please Help!!!!