Count a value change in cells Closed

Question

Hi, I'm trying to count how many times did 1 cell from a row has been changed from 1 to 0 and then back to 1, how many times did this form of change happened.

For example:

1|0|1|0|0|0|1|0|0|0|0|0|0|0|0|0|1|0|0|0|0

I'm counting the changes between even columns aside from counting in odd columns.
So the count here is 2 from what I'm trying to do.

Here's a file for more understanding:
https://www10.zippyshare.com/v/Ff0ioaqm/file.html

Thanks for the help!

TrowaD · Answer

Hi MindTwister,

Your query is not clear to me.

When I look at your example, looking at the odd columns I get:
1 1 0 1 0 0 0 0 1 0 0
Here I count 5 changes from 1 to 0 and from 0 to 1.

The even columns are only 0's so the count there would be 0. So I don't understand how you would get a result of 2.

In your file, you are just counting the odd and even columns, which could be done more effectively by using SUMIF, as in:
=SUMIF(A1:AZ2,"A",A2:AZ2)

Best regards,
Trowa

Count a value change in cells

1 response

Similar discussions

Subscribe To Our Newsletter!