Help with excel formula

[Lilbemer]

I am stuck, please help. If column A is total of project costs, column B lists complete, in progress or not started, column c lists payments received. I need a formula that will subtract the payments received from total cost of project, only is column b states complete. I know I can do line by line but is there a better way to cover all three columns multiple rows with one formula? I hope this makes sense. Thank you. The sum ifs does not work.

 

[Lilbemer]

Here is an example of what i am asking. Thank you

 

[Fluff]

Hi & welcome to MrExcel.
How about

=SUMPRODUCT((B2:B6="Complete")*(A2:A6-C2:C6))

 

[Lilbemer]

Hi & welcome to MrExcel.
How about

=SUMPRODUCT((B2:B6="Complete")*(A2:A6-C2:C6))

Thank you so much! I really apprecite your help.

 

[Fluff]

You're welcome & thanks for the feedback.