Hi Rick,

You have a syntax error (missing closing parenthesis): sum($r4+$t40
correct: sum($r4+$t4)0

But I can't tell wether your formula gives the result you want, because you
don't tell us what you want exactly!

Regards,
Stefi

€žRick€� ezt Ã*rta:

If "A" is constant for both or conditions, how does one write the if
statement? I tried to do this and got and error:
If(or($b4="UA", sum($r4+$t40, and($a4="S")),1,2)
--
Rick Rack