Data Counting

Hi,
Apologies if this is listed elsewhere ...
I have a column that reads
Yes
Yes
No
No
Yes
No

I want to count how many times it says "Yes" or "No" before it changes
I have a huge spreadsheet to analyze and this would make it much quicker

Using Excel 2010 and 2013

Thanks

Carl

Almir's picture

Solution to Count Before Change

I have re-read your post and figured this out:: http://excelexperts.com/solution-count-change

Almir's picture

Use COUNTIF to count items conditionally

Use COUNTIF to count items conditionally:
=COUNTIF("A1:A100","Yes") - to count number of "Yes"
=COUNTIF("A1:A100","No") - to count number of "No"

Vikas Verma's picture

Try this

Hi Carl,

use this one...hope u are looking for the same...
=SUM((A1:A20="Yes")*1)

Column a Column B
Yes Put formula here
No
No
Yes
Yes
Yes
No
No
Yes
Yes
Yes
No
No
Yes
Yes
Yes
No
No
Yes
Yes

Hi Almir and Vikas, Thank you

Hi Almir and Vikas,
Thank you so much for that ...
Your speedy replies are much appreciated

Almir you are right on the money with your solution - count - change post

Thanks Guys you have saved me a huge headache