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.
