Formula assistance using "Sumifs"

Brittanyy

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

Paul Newcome

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