SUMIF for multiple criteria's


Hello all,

I am trying to get a SUM from another sheet but only if it meets criteria from another cell.

My cells would be Bulk Weight, Allocation, Strain Name, and THC%.

And I would want to SUM all Bulk Weights that have a certain Allocation, a certain strain Name, and a THC% above 20.

The formula I built out looks like this:

=SUMIF({Vivo Product Stock List Bulk Weight}, "Post-Irradiation THC%" >= 19, "Allocation" = Purchased for AUS, "Strain Name" = Sensi Star)

But its not working, I need help

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!