Excel Examples: Product Code

In this video tutorial we are going to use a few functions to fulfil our requirements. We need to SUM the values of column B as per PRODUCT CODE. Until the SUM value reaches 80 we need to put “V” in column C, 80 to 95 will be “E”, and above 95 will be “D”.  SUMIF function used to sum the range according to “Product Code”. Then the sum values are checked by the IF function. IF function checking the sum value for each row. We make the function dynamic by using multiple functions at a time. For more details watch the video.