Answer:
Throughout the below segment, the solution to the given question is provided.
Explanation:
- The CELL formulas include context justification quantities or properties as well as return failures when evaluated using such a separate Excel dominant language.
- This same CELL function returns configuration, positioning, or specific cell data or documentation relating.
The formula is provided below:
⇒ [tex]In \ I6 \ cell \ use =AVERAGEIF(B4:B34,"FT",D5:D34)[/tex]