sumproduct with multiple constant values

Try: =SUMPRODUCT(--((FLEETCODE="RETAIL")+(FLEETCODE="BRONZE")),--(LOC="FTOYOTA"),--(VEH="TOYOTA"))

Attach a sample file. To do so:
To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),

be sure to desensitize the data
click “Go Advanced” (next to Post Quick Reply – bottom right),
scroll down until you see “Manage Attachments”, click that,
click “Browse”.
select your file(s)
click “Upload”
click “Close window”
click “Submit Reply”
The file name will appear at the bottom of your reply.