Hello,
I have a customer list and I am trying to use it to extract data from another sheet to get customer specific information.
My SUMIFS formula to total the $$ for all projects with a specific customer is working.
=SUMIFS({BidBoard Quoted Value}, {BidBoard Customers Bidding}, HAS(@cell, Customer@row))
But when try to add additional criteria, I am getting #Incorrect Argument
Limit results based on Status:
=SUMIFS({BidBoard Quoted Value}, {BidBoard Customers Bidding}, HAS(@cell, Customer@row),{BidBoard Status}, HAS(@cell, Status@row))
Limit result based on Date:
=SUMIFS({BidBoard Quoted Value}, {BidBoard Customers Bidding}, HAS(@cell, Customer@row),{BidBoard Bid Date}, AND(ISDATE@cell), @cell >= [Start Date]@row, @cell <= [End Date]@row)
The columns in the sheet I am working in are "Customer" (text/#), "Start Date" (date), "End Date"(date), and "Status"(single select drop down)
The columns in the sheet I am referencing "Quoted Value" (text/#), "Customers Bidding" (multi select drop down), Bid Date (date), and Status (single select drop down).
Am I missing a comma somewhere? Any advice is appreciated.
