SUMIF (calculation formula)

✭✭✭✭✭

I have a formula I need help with:

=SUM([Approved/Contracted Budget \$\$ (Total)]:[Approved/Contracted Budget \$\$ (Total)]) + SUMIFS([Requested Study Budget (Submission)]:[Requested Study Budget (Submission)], [Approved/Contracted Budget \$\$ (Total)]:[Approved/Contracted Budget \$\$ (Total)], @cell = "", Approved:Approved, 1)

This formula (above) works perfectly and compares 2 columns [Requested Study Budget (Submission)] to [Approved/Contracted Budget \$\$ (Total] and whatever one has a \$\$ amount, it adds to the [Approved/Contracted && (Total).

Now, I need to add another column into the mix and compare that one, as well. HELP!

So, if I had a 3rd column, how do I write that formula, if everything else remains the same.

Susan

• ✭✭✭✭

It would help to understand what you need to sum or compare from the third column. Can you provide more details?

Director of Technology & Innovation 💡 at Streamline

CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony

• ✭✭✭✭✭

All of the columns are a \$\$ Amount, for example:

Column 3: Contracted \$\$ Amount (1st), if that is filled in (SUM that) +

Column 1: Requested Budget \$\$ Amount (Submission)

Column 2: Requested Budget \$\$ Amount (After Review)

Column 1 is always completed 1st (after Submission) ; if I approve and contract with the site, I complete Column 3 (Contracted \$\$ Amount); IF they site comes back and says (now, I need more \$\$), I would complete Column 2 (After Review).

I need the formula to compare ALL 3 columns; always looking at Column 3 (1st) and then ADDING that Column to 1 or 2, depending on if they are completed or blank.

Make sense?

Column 1 (always filled out); Column 2 (doesn't have to be filled out).

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!