Sleeper: Need help to change a formula

[oliver]

I need help with this formula.

=SUM(H7,N7,T7,V7,Y7)+IF($AD7=6200,0,$AC7)+IF($AA7=6240,0,$Z7)-SUM(AH7:AU7) .
I would like to include this line in the formula.

+IF($AA7=6200,0,$Z7)+IF($AA7=6240,0,$Z7)
Thanks,
Oliver

[MaximS]

what's the problem??

try it that way:



=SUM(H7,N7,T7,V7,Y7)+IF($AD7=6200,0,$AC7)+IF($AA7=6240,0,$Z7)-SUM(AH7:AU7)+IF($AA7=6200,0,$Z7)+IF($AA7=6240,0,$Z7)

[oliver]

thanks for the reply but that combination still didn't give the required results. I think it needs to be added before the -SUM(AH7:AU7) part.
Hopefully the attached sample will better show what I need.
thanks
oliver

[MaximS]

According to your example both parts of added line:


+IF($AA7=6200,0,$Z7)

and


+IF($AA7=6240,0,$Z7)

are refering to the same cell "Z7" which is empty.

In other words you won't see the difference untill you insert some value into "Z7" or change one of the references from "Z7" to i.e "Z8".

[Bob Phillips]

You don't even attempt explain what you are trying to do, why, or what your expected result is, so this is a pure guess


=SUM(H2,N2,T2,V2,Y2)+IF($AD2=6200,0,$AC2)+IF($AA2=6240,0,$Z2)
-(SUM(AH2:AU2)+IF($AA2=6200,0,$Z2)+IF($AA2=6240,0,$Z2))