How to fix formula returning "FALSE"

[Sean15]

Hi:

In column I, for example, All values for "Alice" needs to be summed or grouped together to the first occurring "Alice". All duplicates of "Alice" need to show 0 but formula is returning "FALSE"

Could you fix formula please?

Excel 2010
	A	B	C	D	E	F	G	H	I	J
1	Customer		Oct	Nov	Dec	Jan	Feb		Total
2	Alice		-	-	3,234.00	-	2,464.00		7,289.00
3	Alice		-	-	999.00	-	592.00		FALSE	required value 0
4	Tom		-	-	-	577.50	577.50		8,150.00
5	Tom		-	1,925.00	1,925.00	1,665.00	1,480.00		FALSE	required value 0
6	Ryan		-	-	-	-	1,925.00		1,925.00
7	Courtyard		-	-	-	-	740.00		740.00
8	Double		-	-	-	-	96.25		540.25
9	Double		-	-	-	-	444.00		FALSE	required value 0
10	Face		-	-	-	11,550.00	-		11,550.00
11
Bytemark pass type & sales (2)

Cell Formulas
Range	Formula
I2	=IFERROR(IF(COUNTIF(A$2:A2,A2)=1,SUMPRODUCT(($A$2:$A$10=A2)*($C$2:$G$10))),"")
I3	=IFERROR(IF(COUNTIF(A$2:A3,A3)=1,SUMPRODUCT(($A$2:$A$10=A3)*($C$2:$G$10))),"")
I4	=IFERROR(IF(COUNTIF(A$2:A4,A4)=1,SUMPRODUCT(($A$2:$A$10=A4)*($C$2:$G$10))),"")
I5	=IFERROR(IF(COUNTIF(A$2:A5,A5)=1,SUMPRODUCT(($A$2:$A$10=A5)*($C$2:$G$10))),"")
I6	=IFERROR(IF(COUNTIF(A$2:A6,A6)=1,SUMPRODUCT(($A$2:$A$10=A6)*($C$2:$G$10))),"")
I7	=IFERROR(IF(COUNTIF(A$2:A7,A7)=1,SUMPRODUCT(($A$2:$A$10=A7)*($C$2:$G$10))),"")
I8	=IFERROR(IF(COUNTIF(A$2:A8,A8)=1,SUMPRODUCT(($A$2:$A$10=A8)*($C$2:$G$10))),"")
I9	=IFERROR(IF(COUNTIF(A$2:A9,A9)=1,SUMPRODUCT(($A$2:$A$10=A9)*($C$2:$G$10))),"")
I10	=IFERROR(IF(COUNTIF(A$2:A10,A10)=1,SUMPRODUCT(($A$2:$A$10=A10)*($C$2:$G$10))),"")

Thanks


Regards,
Sean

 

[Fluff]

Try
=IFERROR(IF(COUNTIF(A$2:A2,A2)=1,SUMPRODUCT(($A$2:$A$10=A2)*($C$2:$G$10)),0),"")

 

[Sean15]

Excellent. Thank you.

Regards,

Sean

 

[Fluff]

You're welcome & thanks for the feedback