CS Challenge W7

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

Leave a Reply

Your email address will not be published. Required fields are marked *