How to sum multiple rows and columns in excel
By
SpreadCheaters
Page last updated:
19/11/2022 |
Next review date:
19/11/2024
You can watch a video tutorial here.
You have numbers in multiple rows and columns that need to be calculated.
There’s an easy way to do this:
Step 1 – Creating your formula
– Select the cell you would like your result to appear.
– Type =SUM(A2:B11), where A2:B11 references the cells containing the numbers to be calculated.
– Press Enter.
This is an easy way to sum multiple rows and columns in Excel.
