Forum Discussion
and_rogynous
Sep 21, 2022Copper Contributor
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...
- Sep 21, 2022Everything 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]
HansVogelaar
Sep 21, 2022MVP
Why not use the same criteria as in your order count formula?
=IF([@Customer]="","",SUMIFS(Orders[Pcs],Orders[Shipped],">=4/1/2022",Orders[Shipped],"<5/1/2022",Orders[Customer],[@Customer]))
Or else take [@Customer] outside the quotes:
=IF([@Customer]="","",SUMIFS(Orders[Pcs],Orders[Shipped],">=4/1/2022",Orders[Shipped],"<5/1/2022",Orders[Customer],"="&[@Customer]))
but that seems unnecessary.
and_rogynous
Sep 22, 2022Copper Contributor
The latter worked without the "="& which is perfect I didn't know the [@Customer] had to be outside the quotations, that explains a lot.