Formula assistance using "Sumifs"

Hi everyone, I need assistance on a formula.

The formula I want to create will sum the up the number column "Qty of Monitor" if "Office" is SEA and the " Monitor"column displays Viewsonic

Formula below is on my metric sheet. The columns are being referenced.

=SUMIFS({Qty of Monitor}, {Office}, "SEA", {Monitor}, "Viewsonic")

I tried using Countif, but I kept getting an error.

Also if I use this formula on the main sheet would it look like this.

=SUMIFS({Qty of Monitor: Qty of Monitor}, {Office:Office}, "SEA", {Monitor:Monitor}, "Viewsonic")

Thanks in advance

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you getting an error message, or having some other issue? The syntax of your SUMIFS is technically correct.

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.