Try this:

=IF(AND(Worksheet!N358=TRUE,Worksheet!N360=TRUE,Wo rksheet!N355=TRUE,OR(Worksheet!N376={TRUE,FALSE})) ,SUM('Summary
Sheet'!M34:M42),"NO Data")

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"egarcia" wrote in message
...
Is there a way to combine both these formulas into one.

IF(AND(Worksheet!N358=TRUE,Worksheet!N360=TRUE,Wor ksheet!N355=TRUE,Worksheet!N376=TRUE),SUM('Summary
Sheet'!M34:M42),

IF(AND(Worksheet!N358=TRUE,Worksheet!N360=TRUE,Wor ksheet!N355=TRUE,Worksheet!N376=FALSE),SUM('Summar y
Sheet'!M34:M42),