SUMIFS with 2 Factors

Options
✭✭✭✭✭✭

I am trying to create a formula to SUM a COLUMN/RANGE (Column Title: Budget Requested), IF a BOX is checked in another Column (Column Title: Approved).

Keeps returning #UNPARSEABLE

😑

• ✭✭✭✭✭✭
Options

I should say... SUM that COLUMN if it has a \$10,000 (dollar amount) in the cell; otherwise, don't SUM

• ✭✭✭✭✭✭
Options

For the checkbox:

=SUMIFS([Budget Requested]:[Budget Requested], Approved:Approved, 1)

For the dollar amount of \$10,000:

=SUMIFS([Budget Requested]:[Budget Requested], [Budget Requested]:[Budget Requested], 10000)

• ✭✭✭✭✭✭
Options

How can the 2 be combined? if the box is checked and a \$\$ is in the Budget Requested

• ✭✭✭✭✭✭
Options

NEVERMIND... duh, I wasn't paying attention. @Paul Newcome you were exactly right!! thank you

• ✭✭✭✭✭✭
Options

=SUMIFS([Budget Requested]:[Budget Requested], [Budget Requested]:[Budget Requested], 10000, Approved:Approved, 1)

• ✭✭✭✭✭✭
Options

you were right with the 1st formula... I was only saying "\$10,000" as (if something was in that cell); not necessarily did it have to equal anything.

• ✭✭✭✭✭✭
Options

Please don't forget to mark the most appropriate response(s) as "helpful" so that others searching for a similar solution can know that one may be found here.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!