using sumif based on text

Jonathan LeBlanc

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.

Jonathan LeBlanc

I can't seem to delete this, so I'll say that it started refreshing correctly after I saved then refreshed the entire page.

Jonathan LeBlanc

I can't seem to delete this, so I'll say that it started refreshing correctly after I saved then refreshed the entire page.

Andrée Starå

Hi Jonathan,

If you haven’t already, have a look here on how to ask for the post to be deleted, but do consider adding how you solved it instead because others might be looking for a similar solution.

https://community.smartsheet.com/discussion/64738/faq-how-do-i-post-a-question-edit-or-delete-my-post

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!