Question: what is the formula to calculate the total in excel?
Answer: Click on the cell in your table where you want to see the total of the selected cells.
Enter =sum( to this selected cell.
Now select the range with the numbers you want to total and press Enter on your keyboard. Tip.