Countifs with error #Value!

[masterdineen]

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

Ro

 

[Claus Busch]

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,YEAR(TODAY()))

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

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


Regards
Claus Busch