Step-by-Step 1 – Using the SUMIF Function

Highlight a cell that contains a formula and press control c. Use arrow keys to highlight another cell and press enter. The formula is copied. However, you will notice that cell ranges are adjusted to take effect for the new row or column. ................
................