Question

Task 1A: Calculate Count (1-3) Step 1: Use the =COUNTIF function in the hightlighted Count colunm below to determine the number of projects 1-3. Step 2: Enter the following cell ranges for Quality (B13:B62), Speed (C13:C62), and Costs (D13:D62). Step 3: Use a Criteria of "1" Step 4: Ranges and Criteria must be entered correctly for the function to work. Please refer to the COUNTIF Functions Guide Tab for help on the correct format that should be used. Task 1B: Calculate Count (4-7) Step 5: Use the =COUNTIFS function in the hightlighted Count colunm below to determine the number of projects 4-7. Step 6: Depending on the combinations you are solving for, use the following cell ranges for Quality (B13:B62), Speed (C13:C62), or Costs (D13:D62). Step 7: Use a Criteria of "1" Step 8: Ranges and Criteria must be entered correctly for the function to work. Please refer to the COUNTIF Functions Guide Tab for help on the correct format that should be used. Task 1C: Calculate PIP Percentage Step 9: Use the PIP Percentage colunm to divide each value you generated for the Count colunm by 50 to determine % of each. Task 1D: Calculate PIP Success Step 10: Use the =COUNTIFS function within the PIP Success colunm to determine the number of project(s) that the NEWS BOD found successful. Step 11: Depending on the combinations you are solving for, use the following cell ranges for Quality (B13:B62), Speed (C13:C62), or Costs (D13:D62), as well as, Results (H13:H62). Step 12: Then, divide the =COUNTIFS function by 50. Projects | Count | PIP Percentage | PIP Success Quality (1) | 29 | 58% | 58% Speed (2) | 29 | 58% | 1 Costs (3) | 26 | 52% | 52% Quality & Speed (4) | 12 | 24% | 24% Quality & Costs (5) | 11 | 22% | 22% Speed & Costs (6) | 16 | 32% | 32% Quality, Speed, Costs (7) | 5 | 10% | 10%

          Task 1A: Calculate Count (1-3)
Step 1: Use the =COUNTIF function in the hightlighted Count colunm below to determine the number of projects 1-3.
Step 2: Enter the following cell ranges for Quality (B13:B62), Speed (C13:C62), and Costs (D13:D62).
Step 3: Use a Criteria of "1"
Step 4: Ranges and Criteria must be entered correctly for the function to work. Please refer to the COUNTIF Functions Guide Tab for help on the correct format that should be used.

Task 1B: Calculate Count (4-7)
Step 5: Use the =COUNTIFS function in the hightlighted Count colunm below to determine the number of projects 4-7.
Step 6: Depending on the combinations you are solving for, use the following cell ranges for Quality (B13:B62), Speed (C13:C62), or Costs (D13:D62).
Step 7: Use a Criteria of "1"
Step 8: Ranges and Criteria must be entered correctly for the function to work. Please refer to the COUNTIF Functions Guide Tab for help on the correct format that should be used.

Task 1C: Calculate PIP Percentage
Step 9: Use the PIP Percentage colunm to divide each value you generated for the Count colunm by 50 to determine % of each.

Task 1D: Calculate PIP Success
Step 10: Use the =COUNTIFS function within the PIP Success colunm to determine the number of project(s) that the NEWS BOD found successful.
Step 11: Depending on the combinations you are solving for, use the following cell ranges for Quality (B13:B62), Speed (C13:C62), or Costs (D13:D62), as well as, Results (H13:H62).
Step 12: Then, divide the =COUNTIFS function by 50.

Projects | Count | PIP Percentage | PIP Success
Quality (1) | 29 | 58% | 58%
Speed (2) | 29 | 58% | 1
Costs (3) | 26 | 52% | 52%
Quality & Speed (4) | 12 | 24% | 24%
Quality & Costs (5) | 11 | 22% | 22%
Speed & Costs (6) | 16 | 32% | 32%
Quality, Speed, Costs (7) | 5 | 10% | 10%

Task 1A: Calculate Count (1-3)
Step 1: Use the =COUNTIF function in the hightlighted Count colunm below to determine the number of projects 1-3.
Step 2: Enter the following cell ranges for Quality (B13:B62), Speed (C13:C62), and Costs (D13:D62).
Step 3: Use a Criteria of "1"
Step 4: Ranges and Criteria must be entered correctly for the function to work. Please refer to the COUNTIF Functions Guide Tab for help on the correct format that should be used.

Task 1B: Calculate Count (4-7)
Step 5: Use the =COUNTIFS function in the hightlighted Count colunm below to determine the number of projects 4-7.
Step 6: Depending on the combinations you are solving for, use the following cell ranges for Quality (B13:B62), Speed (C13:C62), or Costs (D13:D62).
Step 7: Use a Criteria of "1"
Step 8: Ranges and Criteria must be entered correctly for the function to work. Please refer to the COUNTIF Functions Guide Tab for help on the correct format that should be used.

Task 1C: Calculate PIP Percentage
Step 9: Use the PIP Percentage colunm to divide each value you generated for the Count colunm by 50 to determine % of each.

Task 1D: Calculate PIP Success
Step 10: Use the =COUNTIFS function within the PIP Success colunm to determine the number of project(s) that the NEWS BOD found successful.
Step 11: Depending on the combinations you are solving for, use the following cell ranges for Quality (B13:B62), Speed (C13:C62), or Costs (D13:D62), as well as, Results (H13:H62).
Step 12: Then, divide the =COUNTIFS function by 50.

Projects | Count | PIP Percentage | PIP Success
Quality (1) | 29 | 58% | 58%
Speed (2) | 29 | 58% | 1
Costs (3) | 26 | 52% | 52%
Quality Speed (4) | 12 | 24% | 24%
Quality Costs (5) | 11 | 22% | 22%
Speed Costs (6) | 16 | 32% | 32%
Quality, Speed, Costs (7) | 5 | 10% | 10%

Added by Robert H.

Question

Please give Ace some feedback