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


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

and i get #Value!

but when i create the same formula on the support sheet.

ie =COUNTIFS(H9:H250,"Martin",M9:M250,YEAR(TODAY())) and it works.

Is there limits when referencing other sheets in workbook?

Regards

Rob

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