# Finding Current Streaks

#### sebastianmbl

##### New Member
 List 1 Week Home Away Winning Home Draw 1 a b 1 0 2 c d 0 1 3 d a 0 1 4 b c 0 1 5 a c 1 0 6 c b 0 1 7 a d 1 0 8 a c 0 1 9 d b 1 0 10 d a 0 1

<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>
 List 2 Teams Current Winning Streaks Current Draw Streaks a 3 3 b c d

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 question 1 Find all "a" in B column (B3:B12) and results in D column (D3:D12) then calculate the current streak ( as Current Streaks is 3 in example) question 2 Find all "a" in B&C columns (B3:C12) and results in E column (D3:D12) then calculate the current streak ( as Current Streaks is 3 in example)

<colgroup><col span="3"></colgroup><tbody>
</tbody>

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

#### Marcílio_Lobão

##### Well-known Member
sebastianmbl, Good evening.

List 1
 A B C D E 1 2 Week Home Away Winning Home Draw 3 1 a b 1 0 4 2 c d 0 1 5 3 d a 0 1 6 4 b c 0 1 7 5 a c 1 0 8 6 c b 0 1 9 7 a d 1 0 10 8 a c 0 1 11 9 d b 1 0 12 10 d a 0 1

<tbody>
</tbody>

 H I J 1 2 Teams Current Winning Streaks Current Draw Streaks 3 a Formula1 Formula2 4 b 5 c 6 d

<tbody>
</tbody>

Try to use:

I3 --> Formula1 --> =SUMIF(\$B\$3:\$B\$12, H3, \$D\$3:\$D\$12)

J3 --> Formula2 --> =SUMIF(\$B\$3:\$B\$12, H3, \$E\$3:\$E\$12) + SUMIF(\$C\$3:\$C\$12, H3, \$E\$3:\$E\$12)

Copy them down.

Result must be:
 H I J 1 2 Teams Current Winning Streaks Current Draw Streaks 3 a 3 3 4 b 0 2 5 c 0 4 6 d 1 3

<tbody>
</tbody>

Is that what you want?
I hope it helps.

#### Anand Sharma

##### Board Regular
Use the below mentioned code

 Current Winning Streaks Current Draw Streaks SUMIF(C4:C13,B19,E4:E13) SUMIF(D4:D13,B19,F4:F13)+SUMIF(C4:C13,B19,F4:F13)

<colgroup><col><col></colgroup><tbody>
</tbody>

Replies
6
Views
486
Replies
10
Views
1K
Replies
13
Views
283
Replies
11
Views
422
Replies
0
Views
1K

1,195,858
Messages
6,011,979
Members
441,661
Latest member
Pammie007

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back