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