I need the quantity total of specific intelligent part numbers in a list.
example:

(part_no) (quantity)
CV5P1/NL/WIN/NC 1000
CV5P1/SV/WIN 500
ELFAER/NL/MVS 15
CV4/NL/AIX 500
ACI/NL/WIN 121

I'd like to use the custom autofilter to filter/extract on rows that contain
multiple "contains" options like the following to get the desired result so I
can use the =SUBTOTAL(109,ref1,ref2) function on the filtered total quantity,
but only two evaluations fields are available under the custom autofilter.

example criteria:
part_no contains "NL" AND
part_no does not contain "NC" AND
part_no does not contain "CV4*" AND
part_no does not contain "CV5*"
....

example result:
ELFAER/NL/MVS 15
ACI/NL/WIN 121
Filtered Total Quantity = 136

Is there a way to add more fields to the custom autofilter? Do I need to
use the advanced filter to get this info and if so, how should I specify the
criteria text to get the desired result?