=COUNTA(Status_Range_Where_Completed) / COUNTA(Status_Range)
=SUMPRODUCT(Hours_Actual_Range, Hourly_Rate_Range)