=COUNTIF(AnotherSheet!$T$3:$BB$5000,A1)

--
KL
[MVP - Microsoft Excel]
RU: http://www.mvps.ru/Program/Default.aspx
ES: http://mvp.support.microsoft.com/?LN=es-es
EN: http://mvp.support.microsoft.com/?LN=en-us
Profile: https://mvp.support.microsoft.com/pr...A-9E6C73C09A36


"Curtis" wrote in message ...
I need to count the number of times a value, located in $A1 of one sheet
appears in a range of $T$3:$BB$5000 in another sheet

Thanks

ce