SUMIFS error with Multiple Criteria - Invalid Operation?

Meredith Krueger

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)

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

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. 👍️