Sum unique values

[creative999]

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
	A	B	C
1	STATUS	SELL PRICE	REF
2	START	300	RET5644403
3	FINISHED	200	RET77600004
4	FINISHED	150	RET5644403
5	TBC	200	RET5644403
6	FINISHED	200	RET77600004
7	FINISHED	150	RET5644403
8	TBC	200	RET77600004
Sheet2

 

[kweaver]

First thing I came up with was:

Book5
	A	B	C	D	E
1	STATUS	SELL PRICE	REF
2	START	300	RET5644403		1350
3	FINISHED	200	RET77600004
4	FINISHED	150	RET5644403
5	TBC	200	RET5644403
6	FINISHED	200	RET77600004
7	FINISHED	150	RET5644403
8	TBC	200	RET77600004
9	FINISHED	1000	RET9999
Sheet1

Cell Formulas
Range	Formula
E2	E2	=SUM(INDEX(UNIQUE(FILTER(A2:C9,A2:A9="FINISHED")),,2))

 

[igold]

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

 

[kweaver]

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

 

[creative999]

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.

 

[igold]

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

 

[kweaver]

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?

 

[igold]

@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...

 

[Fluff]

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.

 

[igold]

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