Hi Rob,

Am Thu, 9 Aug 2012 07:56:18 +0000 schrieb masterdineen:

I am using the following formula to reference a sheet called SUPPORT

=COUNTIFS(SUPPORT!H8:H25,"Martin",SUPPORT!M9:M25,Y EAR(TODAY()))
^^^^^^^^^ ^^^^^^^^^

try:
=COUNTIFS(SUPPORT!H8:H25,"Martin",SUPPORT!M8:M25,Y EAR(TODAY()))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2