# Number of Occurences Totaled in separate column

#### tm1422

##### New Member
Hello, in the below table i'd like to add a column summing the occurences of same week # for each store.

for example - Store 115 - 1 for 49, 50, 51, 52
store 160 - 1 for 50, 51, 52
store 161 - 2 for 49, 2 for 50

 Week # Store # 49 Store ##00115 50 Store ##00115 51 Store ##00115 52 Store ##00115 50 Store ##00160 51 Store ##00160 52 Store ##00160 49 Store ##00161 49 Store ##00161 50 Store ##00161 50 Store ##00161

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

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

#### sunny102

##### Board Regular
Hi,

Just write all the unique values in column D and apply this formula in column E

=SUMIF(B:B,D2,A:A)

I'm online and able to respond in real time to you until it's solved.

##### MrExcel MVP
Set up a pivot table...

Store # to ROWS, Week # to COLUMNS, and Store # to VALUES where you replace Sum with Count.

 Row\Col A​ B​ C​ D​ E​ F​ 3​ Count of Week # Column Labels 4​ Row Labels 49​ 50​ 51​ 52​ Grand Total 5​ Store ##00115 1​ 1​ 1​ 1​ 4​ 6​ Store ##00160 1​ 1​ 1​ 3​ 7​ Store ##00161 2​ 2​ 4​ 8​ Grand Total 3​ 4​ 2​ 2​ 11​

#### tm1422

##### New Member
I don't under the "unique values" in column D reference.

Just write all the unique values in column D and apply this formula in column E

=SUMIF(B:B,D2,A:A)

I'm online and able to respond in real time to you until it's solved.

See post #3...

#### sunny102

##### Board Regular
Write all the unique store numbers in D2,D3,D4 and so on, so if you have 3 unique stores write Store ##00115 in D2, Store ##00160 in D3 and so on...
I don't under the "unique values" in column D reference.

Replies
4
Views
970
Replies
5
Views
466
Replies
2
Views
267
Replies
0
Views
315
Replies
1
Views
2K

1,191,532
Messages
5,987,127
Members
440,080
Latest member
drhorn4908

### 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