Excel Tips, Tricks, and Shortcuts

How do you sum values in an Excel worksheet? How many ways do you know to deal with it? Which way do prefer most? Forget it if you are thinking about the answer. Today, I bring you the four ways of sum values in a worksheet that you can pick to use it as yours. Look at images for your own illustrate practice. i. To use Σ (Sigma sign) Click on cell [A7] Click on [Σ] symbol ii. To use the two shortcut key Click on cell [A7] Click on [Alt] [=] iii. Use formula “ =SUM() ” Click on cell [A7] To type [=] [sum] [(]; {equal sign (=), a formula (sum) and an open parenthesis ( ( )} Use mouse click and select cells [A1] to [A6] To type [ ) ]; {a close parenthesis} iv. Use plus (+) and type on cell manually. Click on cell [A7] Type [=] [A1+A2+…A6] Hope you would love one out of four ways to calculate yours number. To me, I like to use the second method. I think it is cool. See more another tips: How To Use AVERAGEIF Formula "Not" Including “0” (...