Forum Discussion
Solved
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...
- 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]
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]
Orders[Customer], "="&[@Customer]
When omitted, the "=" should be implied:
Orders[Customer], [@Customer]
- This worked perfectly! I didn't realize it had to be outside the quotations, and I didn't realize I could omit the "="& all together; thank you so much!