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

 

[Fluff]

Will the data in those other colums be the same for each ref number?

 

[creative999]

Will the data in those other colums be the same for each ref number?

Mostly yes but some variations in date / time stamps like in the example above

 

[Fluff]

Ok, how about

+Fluff 1.xlsm
	A	B	C	D	E	F	G
1	STATUS		SELL PRICE		REF
2	START	44565	300	a	RET5644403		3350
3	FINISHED	44563	200	b	RET77600004
4	FINISHED	44565	150	c	RET5644403
5	TBC	44566	200	d	RET5644403
6	FINISHED	44564	200	e	RET77600004	this is being included in the formula
7	FINISHED	44565	150	f	RET5644403
8	TBC	44567	200	g	RET77600004
9	FINISHED	44569	1000	h	RET9999
10	FINISHED	44569	2000	i	RET99990
11	XXXX	44562	1000	j	RET123456
12	FINISHED	44569	1000	k	RET9999
13	FINISHED	44569	2000	l	RET99990
Data

Cell Formulas
Range	Formula
G2	G2	=SUM(INDEX(UNIQUE(FILTER(FILTER(C2:E13,A2:A13="FINISHED"),{1,0,1})),,1))

 

[creative999]

Ok, how about

+Fluff 1.xlsm
	A	B	C	D	E	F	G
1	STATUS		SELL PRICE		REF
2	START	44565	300	a	RET5644403		3350
3	FINISHED	44563	200	b	RET77600004
4	FINISHED	44565	150	c	RET5644403
5	TBC	44566	200	d	RET5644403
6	FINISHED	44564	200	e	RET77600004	this is being included in the formula
7	FINISHED	44565	150	f	RET5644403
8	TBC	44567	200	g	RET77600004
9	FINISHED	44569	1000	h	RET9999
10	FINISHED	44569	2000	i	RET99990
11	XXXX	44562	1000	j	RET123456
12	FINISHED	44569	1000	k	RET9999
13	FINISHED	44569	2000	l	RET99990
Data

Cell Formulas
Range	Formula
G2	G2	=SUM(INDEX(UNIQUE(FILTER(FILTER(C2:E13,A2:A13="FINISHED"),{1,0,1})),,1))

Thank you... this seemed to work. Thank you all for all your help on this..

 

[Fluff]

Glad we could help & thanks for the feedback.