SUMIFS error with Multiple Criteria - Invalid Operation?

This one works but needs criteria to count only if cell shows "Flexo" =SUMIF(JobDelDate:JobDelDate, @cell = SchDates@row, EstIAJobs:EstIAJobs)

Getting Invalid Operation error with this one:

=SUMIFS(JobDelDate:JobDelDate, @cell = SchDates@row, PrintTech:PrintTech, ="Flexo", EstIAJobs:EstIAJobs)

Find more posts tagged with

Accepted answers

Paul Newcome

SUMIFS has a different syntax. The range to sum should be the first range in that function.

=SUMIFS(EstIAJobs:EstIAJobs, JobDelDate:JobDelDate, @cell = SchDates@row, PrintTech:PrintTech, @cell = "Flexo")

All comments

AdamSYNH

Hi @Meredith Krueger,

Try removing the "=" before "Flexo"

The way you seem to want the formula to work, "Flexo" alone is your criteria. You're not using the value in the PrintTech column in the row your formula is in as one of the criteria to count in your SUMIFS. The adjustment above will essentially hard code the formula to only count rows where "Flexo" is in the PrintTech column. If this answers your question please mark it as answered, if you want something different, please do reply and tag me to let me know.

Meredith Krueger

Hi Adam,

I removed the "=" and received the same error.

=SUMIFS(JobDelDate:JobDelDate, @cell = SchDates@row, PrintTech:PrintTech, "Flexo", EstIAJobs:EstIAJobs)

Paul Newcome

SUMIFS has a different syntax. The range to sum should be the first range in that function.

=SUMIFS(EstIAJobs:EstIAJobs, JobDelDate:JobDelDate, @cell = SchDates@row, PrintTech:PrintTech, @cell = "Flexo")

Meredith Krueger

PERFECT! That worked. Thanks so much!

Paul Newcome

Happy to help. 👍️

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.