Looking for Formula

americansurveymanagement35236

Based on the below screenshots, I am looking for a formula to SUM the FEE column only if the Project Stage column is equal to "Paid". I feel I am close to solving the formula. Any suggestions will be greatly appreciated.

rjudenberg

Try

SUMIF([Project Stage}:[Project Stage},"Paid", FEE:FEE)

Earl Bennett

You could try something like this.  Not very elegant though.  I may look at this a bit more after work .

 

=SUMIF([Project Stage]2:[Project Stage]19, "PAID", FEE2:FEE19)

Earl Bennett

Ah, sorry...  Looks like rjudenberg has the answer.

Mike Wilday

With one minor adjustment rjudenberg had the right answer: 

SUMIF([Project Stage]:[Project Stage],"Paid", FEE:FEE)

His close brackets on the Projects Stage range were curly brackets which could cause some confusion for Smartsheets and curly brackets tend to point to a range in another sheet.

americansurveymanagement35236

This worked perfect, because I am linking to another page the formula came to be this:

=SUMIF({Mimi's Project Management 2018 Range 7}, "Paid", {Mimi's Project Management 2018 Range 3})

and

=SUMIF({Mimi's Project Management 2018 Range 7}, "Invoiced", {Mimi's Project Management 2018 Range 3})

Thank you rjudenberg!