Trying to SUM a column in a Report

[DanielR]

I am trying to sum a column when project status is either "Completed" or "Deffered".

With the following it works fine:
=Sum(IIf([Project Status]=("Completed"),[Funds Commited],0))

However when I do this, I get an error:
=Sum(IIf([Project Status]=("Completed", "Deffered"),[Funds Commited],0))

I also tried but it doesn't work:
=Sum(IIf([Project Status]=Eval(("Completed","Cancelled")),[Funds Commited],0))

 

[DanielR]

I solved it:
=Sum(IIf([Project Status]="Completed" Or [Project Status]="In Progress",[Funds Commited],0))