# Sum unique values

#### creative999

##### Board Regular
Trying to do a sum of column B if col A = Finished (and where col c value is unique).
For example

'Finished' should = 350

Book3
ABC
1STATUSSELL PRICEREF
2START300RET5644403
3FINISHED200RET77600004
4FINISHED150RET5644403
5TBC200RET5644403
6FINISHED 200RET77600004
7FINISHED150RET5644403
8TBC200RET77600004
Sheet2

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
First thing I came up with was:

Book5
ABCDE
1STATUSSELL PRICEREF
2START300RET56444031350
3FINISHED200RET77600004
4FINISHED150RET5644403
5TBC200RET5644403
6FINISHED200RET77600004
7FINISHED150RET5644403
8TBC200RET77600004
9FINISHED1000RET9999
Sheet1
Cell Formulas
RangeFormula
E2E2=SUM(INDEX(UNIQUE(FILTER(A2:C9,A2:A9="FINISHED")),,2))

Rows 3 & 4 match Rows 6 & 7 respectively. Where is the uniqueness you are referring to...

Found a case where my initial approach didn't work. Rechecking?

Rows 3 & 4 match Rows 6 & 7 respectively. Where is the uniqueness you are referring to...
The uniqueness should be based on col c. Rows 6 and 7 should not be included.

There is only one unique value in column C @ C9.

When there are duplicates in column C, will the corresponding values in B also be the same? So, B3 will be the same as B6 because the C columns are the same?

@kweaver the post does not make sense. If you look at the very first line of Post #1 the OP is looking for unique values in Column C when Column A = Finished. That criteria does not exist in the sample data provided...

The majority of times an OP says unique, they actually mean distinct. I would have thought you'd have realised that by now, given your number of posts & length of time you have been a member here.

@Fluff perhaps you can explain the difference between Unique and Distinct and how can it be applied here...

Replies
2
Views
96
Replies
1
Views
166
Replies
4
Views
376
Replies
3
Views
95
Replies
3
Views
214

1,203,752
Messages
6,057,152
Members
444,908
Latest member
Jayrey

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