sumproduct syntax

Most definitely SUMIFS, and since you have 2007+ it is way more efficient, but knowing SUMPRODUCT is still appropriate because you will run into situations where the SUMIFS will not work.

=SUMIFS($C$9:$C$20,$A$9:$A$20,"Ford",$B$9:$B$20,"A")

Basically the SUMPRODUCT produces a bunch of TRUE/FALSE and the * converts it into 1/0.

Finally, all the 1/0 are multiplied by the last range which produces the final result.

The best learning tool to see what is happening besides the link I shared earlier...

EVALUATE FORMULA
Click on the cell with the formula >> Ribbon >> Formulas >> Formula Auditing >> Evaluate Formula