Countif Help

[Guest]

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

 

[KL]

=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/profile=AB32F8EE-8ED3-4AB9-ADDA-9E6C73C09A36