Absolute and relative references are explained below. Relative reference: If you want to display the same contents in cell "C3" as in the neighboring cell "B3", enter the following in cell "C3": =B3. If you want to display the same content in cell "C3" as in the neighboring cell "B3", enter the following in cell "C3": =B3

The SUMIF function can be used to change the contents of the total according to conditions, and the SUMIFS function can be used to specify multiple conditions. The reason why and how to use the SUMIF...