SUMIF Need Help

Options
Nate420
Nate420 ✭✭
edited 03/08/22 in Formulas and Functions

I want to SUM the total bulk weight of multiple lots from another sheet but only if they meet certain qualifications.

The Sheet I am pulling info from looks like this:

Bulk Weight - Post-Irradiation THC % - Strain Name - Allocation

9000 - 19 - Wappa - Purchased for AUS

8000 - 21 - Sensi - GMP


I want to add all the bulk weight if the THC is over 19, The strain name is Sensi, and the Allocation is Purchased for AUS.

My Formula looks like this but is not working:

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

Best Answer

  • Nate420
    Nate420 ✭✭
    Answer ✓
    Options

    This is the current formula I am using that I cannot get to work:

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

Answers

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    Options

    You are using incorrect function and also the match criteria incorrectly. Function should be SUMIFS as it is multiple criteria and comparison should be Column_Name Range, "Value"

    =SUMIFS({Vivo Product Stock List Bulk Weight}, [Allocation]:[Allocation], "Purchased for AUS",[Post-Irradiation THC %]:[Post-Irradiation THC %],>=19, [Strain Name]:[Strain Name], "Sensi Star")
    
  • Nate420
    Nate420 ✭✭
    Options

    This helped me understand the formula better thank you for that. But It is still not working for me, I am getting an #UNPARESEABALE error still.

  • Nate420
    Nate420 ✭✭
    Answer ✓
    Options

    This is the current formula I am using that I cannot get to work:

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

  • Nate420
    Nate420 ✭✭
    Options

    I figured it out:

    =SUMIFS({Vivo Product Stock List Bulk Weight}, {Vivo Product Stock List Allocation}, "Purchased for AUS", {Vivo Product Stock List Range 3}, >=19, {Vivo Product Stock List Range 1}, "Sensi Star")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!