Try this:

=IF(AND(Worksheet!N358=TRUE,Worksheet!N360=TRUE,Wo rksheet!
N355=TRUE),SUM('Summary Sheet'!M34:M42),"not specified")

It doesn't seem to matter what the value of Worksheet!N376 is. Also,
you have not specified what to do if the AND( ) function returns
FALSE.

Hope this helps.

Pete


On Feb 6, 7:21 pm, egarcia wrote:
Is there a way to combine both these formulas into one.

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

IF(AND(Worksheet!N358=TRUE,Worksheet!N360=TRUE,Wor ksheet!N355=TRUE,Workshee*t!N376=FALSE),SUM('Summa ry Sheet'!M34:M42),