Windows 7 - Countifs with error #Value!

Asked By masterdineen on 09-Aug-12 03:56 AM
I am using the following formula to reference a sheet called SUPPORT


=COUNTIFS(SUPPORT!H8:H25,"Martin",SUPPORT!M9:M25,YEAR(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




--
masterdineen




Claus Busch replied to masterdineen on 09-Aug-12 10:53 AM
Hi Rob,

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

^^^^^^^^^                          ^^^^^^^^^

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


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