The value in B2 matches the value in C2, so the formula returns TRUE. First, enter the formula in cell D2 and then copy it down to other cells by dragging the fill handle to compare columns B and C row by row. The fill handle is a small green square in the bottom right corner o...
The COUNTIF function counts the number of chances for the total roll number. Here, the range is given $C$3:$H$8 and the criteria is B11. The range is made an absolute reference so it doesn’t adjust when we copy the formula. Then, copy the formula in C11 to other cells by dragg...