SUMIF for multiple criteria's

Nate420

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

Dale Murphy

@Nate420 Have you tried:

dm

Dale Murphy

@Nate420 Have you tried:

dm