How to Calculation repetition Pattern a weeks

[coolzsters]

Please help all master, i'm very confused to create the formula, i want to know how to calculation the repetition down in a weeks,

Here is the Scenario :
Down = 1
Up = 0

ID	Day 1	Day 2	Day 3	Day 4	Day 5	Day 6	Day 7	Count Repetition
WiFi Error	1	1	0	0	1	1	1	2​
Electricity Issue	0	0	1	1	1	0	0	1​

Explanation by rows:
1st row : WiFi Error 2 Times a weeks, First down (day 1 & day 2), and Second down (day 5, day 6, & day 7)
2nd row : Electricity Issue 1 Times a weeks, down at day 3, day 4, day 5

 

[EvonS]

I'm no expert but I don't understand what you're trying to do.

 

[coolzsters]

I'm no expert but I don't understand what you're trying to do.

sorry EvonS... i'm very confused how to create formula at Column "Count Repetition"

 

[EvonS]

What do you want it to calculate? Countif will count the number of times a specified character appears. for example "=Countif(cell_range, 1)" will count number of times 1 appears in a range.

 

[coolzsters]

What do you want it to calculate? Countif will count the number of times a specified character appears. for example "=Countif(cell_range, 1)" will count number of times 1 appears in a range.

dear Evons, I mean when down (1) repeat on a few day was counting only = 1, if that can Up (0) just in 1 or 2 day & then if in next day down again then down was count = 2 in that weeks, sorry if my english not well..

 

[EvonS]

I understand what you mean now. I think you will have to use a macro to do that. That's something I don't know how to do. I hope someone else here can help.

 

[coolzsters]

I understand what you mean now. I think you will have to use a macro to do that. That's something I don't know how to do. I hope someone else here can help.

dear Evons,
ok thx for your time

dear all expert,
is there anyone can help ??? ?