I'm trying to obtain information on how often someone works say a Saturday.
A1 Date
b1 weekday a1
d1 array of types {"E","EN","r"}
tried this returns 0
=SUMPRODUCT((C18:C382="Sat")*(D18:D382=({"E","EN", "r"})))

any help appreciated.

Bart