Posted to microsoft.public.excel.worksheet.functions
|
|
How can I count the # of times the word "Yes" appears in a ran
thank you so much for your prompt respononse
"Bearacade" wrote:
Assuming your range is A1:B10
=COUNTIF(A1:B10, "YES")
--
Bearacade
------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=559451
|