2 SUMIFS NOT equal to 2 variations

Hello,

I've tried the below formula but it doesn't work (instead of SUMIFS A AND SUMIFS B),

This works: =SUMIFS(pay:pay, [Code a]:[Code a], [Code a]@row, [code b]:[code b], "<>apple")

This doesn't work: =SUMIFS(pay:pay, [Code a]:[Code a], [Code a]@row, [code b]:[code b], "<>apple") + SUMIFS(pay:pay, [Code a]:[Code a], [Code a]@row, [code b]:[code b], "<>orange")

sample below, the + is duplicating the result.

How can I do both? adding the "OR" I also couldn't figure out:

=SUMIFS(pay:pay, [Code a]:[Code a], [Code a]@row, [code b]:[code b], OR("<>apple", "<>orange"))

Find more posts tagged with

Formulas

Accepted answers

Dan W

Does this work for you?

=SUMIFS(Pay:Pay, [Code a]:[Code a], [Code a]@row, [Code b]:[Code b], <>"apple", [Code b]:[Code b], <>"Orange")

=SUMIFS(Pay:Pay, [Code b]:[Code b], <>"apple", [Code b]:[Code b], <>"Orange", [Code b]:[Code b], [Code b]@row)

All comments

Dan W

Try removing the = from the second sumifs

A. Rose

Right, my error... my issue is the below formula is giving me the duplicate instead of the exact amount.

=SUMIFS(pay:pay, [Code a]:[Code a], [Code a]@row, [code b]:[code b], "<>apple") + SUMIFS(pay:pay, [Code a]:[Code a], [Code a]@row, [code b]:[code b], "<>orange")

A. Rose

sample below, the + is duplicating the result.

the below also wouldn't work:

=SUMIFS(pay:pay, [Code a]:[Code a], [Code a]@row, [code b]:[code b], OR("<>apple", "<>orange"))

Hollie Green

Can you do a sumif for what it actually is instead of what it isn't that way when you add additional criteria it is still only adding the ones you need and not the ones you don't need.

=SUMIFS(pay:pay, [Code a]:[Code a], [Code a]@row, [code b]:[code b], "banana")

Dan W

Does this work for you?

=SUMIFS(Pay:Pay, [Code a]:[Code a], [Code a]@row, [Code b]:[Code b], <>"apple", [Code b]:[Code b], <>"Orange")

=SUMIFS(Pay:Pay, [Code b]:[Code b], <>"apple", [Code b]:[Code b], <>"Orange", [Code b]:[Code b], [Code b]@row)

A. Rose

Hi @Dan W

Yes! that worked! thanks so much!

Dan W

Great! Glad we got it figured out!

Dan W

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.