Sumproduct Multiple Criteria

[wtsabo]

I'm trying to use sumproduct to calculate an aggregate figure based on multiple criteria but one array has multiple variables.

For example:
=sumproduct(data*(cars="honda")*(year=2013)*(model=(standard,deluxe,luxury))

For the model criteria, what do I need to change in the formula to pull the correct figure?

Thank you for the help

 

[gehusi]

You could use IF(OR(model="standard", model="deluxe", model="luxury"),1,0).

 

[markmzz]

Maybe this:

=SUMPRODUCT(data*(cars="honda")*(year=2013)*(model={"standard","deluxe","luxury"}))

Or

=SUM(SUMIFS(data,cars,"honda",year,2013,model,{"standard","deluxe","luxury"}))

Markmzz