Question: In Excel, demonstrate conditional formatting, the countif function, and 1 other function of your own choosing. You will need to find or create your own data for this!
Answer: Conditional Formatting: Cells highlighted if the value of the units and the total were between the numbers 60-100
Countif was used to see how many of the dates were above 11/01/2016
And for the use your own, I used the sum function to calculate the added total of blocks E9 to E14
File Link: CS.w7