Microsoft Office Forums - View Single Post - formula to work from data column

Thread: formula to work from data column

View Single Post

Old

08-08-2012, 02:35 PM

masterdineen masterdineen is offline

masterdineen is offline

masterdineen uses Windows XP

Windows XP masterdineen uses Office 2010 32bit

masterdineen uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: Aug 2012

Posts: 11

masterdineen is on a distinguished road

Default

now i am trying the following formula

=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?

Reply With Quote