# SUMIF Need Help

Options
✭✭
edited 03/08/22

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

• ✭✭
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

• ✭✭✭✭✭✭
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")
```
• ✭✭
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.

• ✭✭
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")

• ✭✭
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!