The summation function of excel can be a challenge for beginners, but it's actually very intuitive and easy to grasp. This article will help you learn how to sum data from multiple cells through 4 methods. Let's become an excel master together!
1. Simple summation formula.
When the cells you need to sum are consecutive, you can use the sum function. In the bottom right corner of the cell range of the requirement and (for example: h10), enter this formula:
sum(a1:g10)
This formula will calculate the sum of all cells in the range A1 to G10. If you need to change the sum range, just adjust the range of cells in parentheses.
Second, drag and drop to sum.
If you don't need to use formulas, you can do it by simply dragging and dropping. First, select the starting cell of the requirement sum (for example: A1). Then, place your mouse in the bottom right corner of the cell until a small square (fill handle) appears. Next, hold down the left mouse button and drag down to the cell you want to end with (e.g. g10), release the mouse, and you will see a summarized sum value.
3. Shortcut key sum.
For non-contiguous range of cells, you can use alt+e,s,s shortcut key combination to sum. First, select the first cell that requires a sum (e.g. A1), then hold down the Alt key, then press E, S, S in turn. At this point, the mouse will turn into a small plus sign, which you can use to select other cells that require the sum. Once you have made the selection, release the ALT key and Excel will automatically calculate the sum for you.
Fourth, the sum of conditions.
If you need to sum the data based on certain conditions, you can use the sumif function. For example, let's say your data is in the range A1 to B10 and you want to claim out the total value of all "apples", you can enter the following formula in cell C1:
sumif(b1:b10,"Apples",a1:a10)
This formula will find all the cells with the value of "apple" in column B, and find the corresponding values in column A to sum them. You can adjust the conditions and scope according to your actual needs.
These are the four ways to sum data from multiple cells. Through continuous practice and practice, you will definitely be able to master the summation function of Excel and improve your work efficiency.
Through this article, we have introduced 4 ways to sum multiple cell data in detail, hoping it will be helpful to you. Excel's summation function is very commonly used in practical work, and mastering these methods will greatly improve your work efficiency. Whether you are a novice in the workplace or a novice to excel, as long as you continue to practice and learn, I believe you will be able to become an excel master.
Well, that's all for today's sharing, I hope it can be helpful to the other side