You can create some powerful calculations with the EXCEL SUMPRODUCT function by creating a criteria for a selected array. Click here for a step by step tutorial on EXCEL SUMPRODUCT!