What are the formulas I need to use to fit the requirments? Could you provide examples? Is this SUMIF? Ignore all mentions of 2021 the correct year is 2022.

Blue Mercurv General Requirements: 1. No numbers in ANY formulas. You must use cell references in your formulas. 2. No sub-formulas outside of the table. Formulas must be in the table only!l 3. Format all of your values and variables. Make them consistent with the information you are trying to describe so it is easy for your audience to read your information. 4. Make sure your charts have proper titles, dates, and unit of measure indicated in the titles