Forum Discussion

and_rogynous's avatar
and_rogynous
Copper Contributor
Sep 21, 2022

SUMIFS Question - All But One Criteria Work

I have a spreadsheet to keep track of shipments I sent out at my job. The first table is called Orders and has the relevant columns Customer (name), Shipped (MM/DD/YYYY), Carrier (name), and Pcs (nu...
  • JMB17's avatar
    Sep 21, 2022
    Everything inside of quotation marks is interpreted literally (so sumif would literally look for "[@Customer]" in the criteria range. Creating a criteria that includes a cell reference would have to be concatenated like:
    Orders[Customer], "="&[@Customer]

    When omitted, the "=" should be implied:
    Orders[Customer], [@Customer]

Resources