ExcelBanter - How can I count the # of times the word "Yes" appears in a range

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I count the # of times the word "Yes" appears in a range (https://www.excelbanter.com/excel-worksheet-functions/98119-how-can-i-count-times-word-yes-appears-range.html)

Meri

How can I count the # of times the word "Yes" appears in a range

Bearacade

How can I count the # of times the word "Yes" appears in a range

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

Gord Dibben

How can I count the # of times the word "Yes" appears in a range

=COUNTIF(A1:G23,"Yes")

Gord Dibben MS Excel MVP

On Fri, 7 Jul 2006 11:19:01 -0700, Meri wrote:

Meri

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

Meri

How can I count the # of times the word "Yes" appears in a ran

thank you so much for your prompt respononse

"Gord Dibben" wrote:

=COUNTIF(A1:G23,"Yes")

Gord Dibben MS Excel MVP

On Fri, 7 Jul 2006 11:19:01 -0700, Meri wrote:

Meri

How can I count the # of times the word "Yes" appears in a ran

All times are GMT +1. The time now is 02:20 PM.