# Get sum from unique variable

#### gustavoavila

##### New Member
Hello folks,

I'm trying to find a formula to find how many times people appears in a unique project. This an example data:

Table 1
 Column 1 Column 2 Project 1 Jonh Project 2 Paul Project 1 Jonh Project 4 Tim Project 3 Dan Project 2 Paul Project 5 Tim Project 1 Paul Project 8 Paul Project 7 Dan

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

<colgroup><col width="64" span="6" style="width:48pt"></colgroup><tbody>
</tbody>

I'm trying to find this result:

 Tim: 2 Projects Paul: 3 Projects Dan: 2 Projects Jonh: 1 Projects

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

Basically is search how many times Tim appears in a unique's project and summarize them.

I'm trying with sumif() in array but the results are not good.

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

#### Dave Patton

##### Well-known Member
Did you try a Pivot Table?

The formula is an Array Formula; enter it with Ctrl+Shift+Enter not just Enter.

With name criteria in C17; edit as required.

=SUM(IF(FREQUENCY(IF(\$B\$1:\$B\$10=C17,MATCH(\$A\$1:\$A\$10,\$A\$1:\$A\$10,0)),ROW(\$B\$1:\$B\$10)-ROW(B1)+1),1))

Replies
5
Views
184
Replies
9
Views
501
Replies
11
Views
407
Replies
0
Views
166
Replies
18
Views
622

1,195,989
Messages
6,012,718
Members
441,722
Latest member
tpaman1975

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