Conditional Sum Formula

[typewriterguy]

Looking for help with another conditional sum formula.

When either AL6 or AM6 have a value that is not zero or null, I want the formula to sum AJ6, AL6, AM6.

When both AL6 and AM6 have a null/zero value, I want the formula to return a value of "-".

Desired results
AJ6: Original value = 500
AL6: Change1 value = <NULL>
AM6: Change2 value = 50
AP6: Formula <FORMULA>desired result = 550

AJ6: Original value = 500
AL6: Change1 value = <NULL>
AM6: Change2 value = <NULL>
AP6: Formula <FORMULA>desired result= "-"

I tried =IF((AL6,AN6),SUM(AJ6,AL6,AN6),"-"), but it returned a #VALUE message.

 

[xld]

Try

=IF(OR(AL6=0,AL6="",AM6=0,AM6=""),SUM(AJ6,AL6,AM6),"-")

 

[swinglow]

try:

=IF(AND(OR(ISBLANK(AL6),AL6=0),OR(ISBLANK(AM6),AM6=0),"-",SUM(AJ6,AL6,AN6)

 

[Special-K99]

If AL6 and AM6 are not null, you sum AJ6 AL6 AM6 (if theyre zero it wont affect the sum)

Try
=IF(AND(OR(AL6=0,AL6=""),OR(AM6=0,AM6="")),"-",IF(AND(AL6<>"",AM6<>""),SUM(AJ6,AL6,AM6)))

 

[typewriterguy]

Thanks special K!