I'd recommend using SUMIFS (and associated AVERAGEIFS/COUNTIFS etc) - I believe it's quicker than most SUMPRODUCT/SUM(IF array formulas for summing with multiple conditions - also has the advantage that you can specify the whole column but SUMIFS is intelligent enough to only look at the "used range" - array formulas and SUMPRODUCT will calculate for all specified rows, forcing you to either cut back the ranges or use dynamic ranges.

When conditions are more complex SUMPRODUCT and/or array formulas might still be more appropriate