Long IF Formula

[WDB2]

I have the following formula. It works fine up until the last bit. I want it to say if column O says Await Cash & CN OR Awaiting Proceeds.

=SUMIFS('Deal Information 2'!N:N,'Deal Information 2'!D:D,G3,'Deal Information 2'!L:L,"01/10/2011",'Deal Information 2'!F:F,"Red",'Deal Information 2'!O:O,"Await Cash & CN""Awaiting Proceeds")

Anyone able to help me please?????

 

[Gerald Higgins]

Here's one way. It should work as long as no other possible entries in col O begin with "Await".

=SUMIFS('Deal Information 2'!N:N,'Deal Information 2'!D:D,G3,
'Deal Information 2'!L:L,"01/10/2011",'Deal Information 2'!F:F,
"Red",'Deal Information 2'!O:O,"Await*")

 

[WDB2]

Many thanks for your response. Unfortunately, I have a number of others that start with "Await".