SUMPRODUCT for Resource UsageUsing the same door-and-window…

SUMPRODUCT fоr Resоurce UsаgeUsing the sаme dоor-аnd-window data: Plant Door Hours Window Hours Available Hours Plant 1 1 0 4 Plant 2 0 2 12 Plant 3 3 2 18 Suppose the number of doors is in cell B8, the number of windows is in cell C8, and the Plant 3 coefficients, 3 and 2, are in cells B5:C5. Which Excel formula correctly calculates Plant 3 hours used?Source: Adapted from the Wyndor Glass spreadsheet model, Chapter 5.