First of all you need to understand how excel makes it's calculations.
In your formula you are telling excel to total cells Z, AA, AB, & AC 32
if cells S, U, W, & Y32 =YES. It does this correctly. In your next if
statement (next condition) you tell excel to total cell C32 if cell U32
is blank. It does this correctly because condition 1 is now no longer
true. In you next condition you telling excel to contidict it's self by
saying IF cell U32 equals YES, then total cells Z and AA 32. By putting
Yes back in cell U32 unless I'm missing something now tell excel to
return to the first condition which should total 13 the sum of cells Z,
AA, AB, & AC 32. You can have more than 7 nested if's however, you need
to use =CONCATENATE. This will give you 30 conditions to use in your
formula. There is also a way to bypass the 30 conditions but thats
another story. Try to be a little more specific as to what you want the
outcome to be. Hope this helps.

Ed


--
patele
------------------------------------------------------------------------
patele's Profile: http://www.excelforum.com/member.php...o&userid=35849
View this thread: http://www.excelforum.com/showthread...hreadid=566183