Home » Forums » Open Source Learning Center » Question and Answer

Data Counting

Submitted by Carl.o on 20 March, 2014 - 07:15

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

‹ Solution for I want to Input Data in One sheet and move data in another sheet automatically. Find and move the duplicate values in another sheet ›
»
Almir's picture

Solution to Count Before Change

Submitted by Almir on 20 March, 2014 - 08:22.

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

Submitted by Almir on 20 March, 2014 - 08:05.

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

Submitted by Vikas Verma on 20 March, 2014 - 07:31.

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

Submitted by Carl.o on 20 March, 2014 - 19:30.

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

»