I would like to add this criteria to the formula below: [Bin Locations], (all locations that don't begin with "*") A sample of locations I don't want included in the count is "*Vect" and "*Prt". I do want to include all locations that don't begin with an asterisk.
=SUM(SUMIFS([Quantity OnHand],[Item],$A21&"*",[reserved],0,[cond],{"NE","OH","FN"}))
Bookmarks