# Thread: How to fix formula returning "FALSE" Thanks: 0 Likes: 0

1. ## How to fix formula returning "FALSE"

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
ABCDEFGHIJ
1CustomerOctNovDecJanFebTotal
2Alice - - 3,234.00 - 2,464.00 7,289.00
3Alice - - 999.00 - 592.00 FALSE required value 0
4Tom - - - 577.50 577.50 8,150.00
5Tom - 1,925.00 1,925.00 1,665.00 1,480.00 FALSE required value 0
6Ryan - - - - 1,925.00 1,925.00
7Courtyard - - - - 740.00 740.00
8Double - - - - 96.25 540.25
9Double - - - - 444.00 FALSE required value 0
10Face - - - 11,550.00 - 11,550.00
11

Bytemark pass type & sales (2)

Worksheet Formulas
CellFormula
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  Reply With Quote

2. ## Re: How to fix formula returning "FALSE"

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

3. ## Re: How to fix formula returning "FALSE"

Excellent. Thank you.

Regards,

Sean  Reply With Quote

4. ## Re: How to fix formula returning "FALSE"

You're welcome & thanks for the feedback  Reply With Quote

## User Tag List

#### Tags for this Thread

925.00, alice, false, formula, required #### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•