SUMIF Need Help

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)

Find more posts tagged with

Accepted answers

Nate420

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

All comments

Sameer Karkhanis

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

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

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

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.