using sumif based on text

the checking column is called {status}, and consists of won, lost or quoting

the data I'm looking to sum is called {2021 pipeline} and has numbers from a formula.

in a seperate sheet I want to total only the items that have "won" as a status.

in my test, I have 2 projects with won status, and there is numerical data in the {2021 pipeline} column

the formula I'm using is =sumif({status},"won",{2021 pipeline})

the output is only one of the the 2 won projects.

in addition, when I change the criteria to "quoting" or "lost", it sums nothing!

I have confirmed that "won" "quoting" and "lost" are identical in the reference cells.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!