Google Sheets- Simplete functionality

Need someone that can set up a few formulas in our sheet.
Video instructoins on task here: https://watch.screencastify.com/v/E9XqL0y2ULVlMQxbDo01