Making Formula More Shorter-Simple

[Jhon Mustofa]

hi all...

i need someone can make this formula more shorter or simple.
code :

Please Login or Register  to view this content.

any helps, much appreciated..

john m

[Jonmo1]

Shorter/Simpler Does Not necessarily mean Better.

That said, I don't see a shorter or simpler method to do what that formula does.
So the real question is,
Does the formula Do what you want it to do ?

If Yes - Don't Fix it.
If No - What DO you want it to do?

[Glenn Kennedy]

What are you expecting the formula to do? Is it currently working as you want it to work?

[bebo021999]

What do you intent to do with the range D52:F52?

[Jonmo1]

The only 'extremely minor' improvement I can see would be to use counta instead of countif

=IF(COUNTA($D$52:$F$52)<3,SUM($D$52:$F$52)>0,SUM($D$52:$F$52)=1)

But again, it's not necessarily 'better', just shorter (barely).

[Jhon Mustofa]

totaly/sum data must/should be answer 100
e.g.
20+10+75=105 (WRONG)
30+30+30=90 (wrong)
35+35+30=100 (should be)
40+20+40=100 (should be)
etc...

[Jhon Mustofa]

not works
=(100=SUM$A$1:$A$3)

[Jonmo1]

You need (parens) on the sum function, and you do not need the parens on the outside...

=100=SUM($A$1:$A$3)