How to sum different numbers of cells with excel

The answers upstairs are all good, and based on the questions you asked, I suggest you use the following methods;

1.Select the area (including the column headers) in your **;

2.Click on the menu bar"data"-"list"-"Create a list"and click in the Create List dialog box that pops up"OK"(If you select a region that doesn't have column headers, the software will automatically create them.)"Column 1"Column 2"……）

3.click, and a blue border appears in the selected area;

4.Click any cell inside the blue border, a drop-down arrow will appear in the column header bar, and the right side will appear"list"function menu;

5.Click the column header"Product name"next to the drop-down arrow, select the product you need to calculate;

6.Click on the list menu on the right"Toggles summary rows"button, at the bottom of the blue border, the number of products you want to aggregate;

7.Click on the black bold at the bottom of the blue border"Summary", a drop-down arrow will appear, and other calculations can be made"Average","Counting"and so on for a few series of operations.

I can't upload it because my level is not enough**,Please understand!

Sort first - can be lifted and lowered, and then the point data --- classified and summarized.

Or use the sumif function.

You'll be sumsumif, and you'll be fine.

sumif（a1:a3:"a", b1:b3) is equal to the sum of a.

Data – Aggregate by Category, select the data you want to aggregate.

It can be solved with a pivot table or a sumif function.

Assuming that the data is in columns a, b, and c, sumif(a:a,1,c:c) is the sum of 1.

sumif(a:a,2,c:c) is the sum of 2.

It's best to use pivot tables. It is recommended that you learn how to use pivot tables, and this kind of problem will not be a problem in the future.

Assuming the data is in column A, enter in B1

"A1 pull-down padding.

Select column b for the whole column --ctrl+c--right-click-selectively paste --value.

Keep column b selected) Click on the menu bar"Profile--Sort--Done"

The information in column B is the calculation result.

Method 1: Enter the formula =sum(mid(a1,,4)*1) in B1

Method 2: Define a name, such as "sum", and enter =evaluate(substitute(sheet1!$a2,", and then confirm, enter = sum in b1, that is, you get the result you want. Method 2 is more versatile.

Method 3: Use VBA to solve. Enter the VBE environment, insert the module with a loss, and enter the program code:

function cell sum (i as range).

Cell sum = ,"

end function

Go back to the table just now, enter =Sum of cells (A1) in B1 to get the result you want.

Replace cell A1 with a substitution first", replaced"+"

Enter the formula =A2 in cell A1

Then select A2 and copy - Selectively paste - value.

Then ctrl+h ,, replace , query = with =

OK. a4 =SumProduct(--Left(A1:A3)) or =SumProduct(--Left(A1:A3,Find("*a1:a3)-1))

Point A5, insert-name-define nsum =evaluate(a1&"+a2&"+a3), OK, a5 input =nsum

Array formula, press Ctrl+Shift+Enter to finish.

What you want is the result of calculating the equation on the left side of the square.

Select cell A1, click Insert, Name, Definition, enter abc in the name, and =evaluate(a1) in the reference position below, OK. Then enter =abc in the right box of any cell with an equation to get the result.

Enter the equal sign and plus sign in the cell, and then click the cell you want to add, for example:

sheet1!a1 + sheet2!b3 + sheet3!c2

Or enter the following formula:

sum(sheet1!a1:c4,sheet2!b3:f7)

sheet1 is the name of the table, "! It is a sign that follows the name of the table.

For example, if your column numbers are in column a, you want to display the results of their calculations in column b.

Insert -name-define name, give it a random name (aaa), and type =evaluate(a1) in the reference position

Then type =aaa in b1 and drag it down.

1. The software used in the demonstration is Excel Electronics**, and the software version is Office Home and Student Edition 2016.

2. First of all, open Excel Electron**, and enter multiple numbers in the same cell to demonstrate how to sum multiple data in the same cell.

3. Select the column tool under the cell selection data menu, and use the separator space to perform the column operation.

4. After the setting is completed, close the window and you can see that the 4 numbers in the same 1 cell have been sorted at this time, and then use the formula to sum and calculate again.

Method 1: Select Kai Kai Leak to see the staring rot, the count is 6, that is, 6.

Method 2: Formula Sun You calculates = counta(a:a)<>

Figure, summing multiple numbers in column a. 1. Click "Insert", "Name", "Define", and "Define". 2. Fill in the name of a self-finalizer (e.g. GS) in the box under "Name in the current workbook", enter "evaluate(a1)" in the key box under "Reference Position", and click "Add".

Confirm to exit. 3. Enter "GS" enter in cell B1 to get the result of the formula of cell A1 (1+2+3 6). 4. Move the mouse to the lower right corner of cell B1, the cursor changes to a black cross, hold down the left mouse button and drag down to B4, you can get the corresponding result.

Figure, add the numbers in column A. Click "Insert" - "Title" - "Definition". 2.

Enter your own name (e.g. GS) in the Current Book Name box, type =evaluate(a1)", and click Add. It's definitely an export. 3.

Input cell B1 "=GS" will tartarily bend back to the result of the formula for cell A1 (1+2+3=6). 4. After moving the mouse cursor to the lower right corner of cell B1, the cursor changes to a black cross, hold down the left button of the mouse Qi marker, and drag it down to B4 to get the result of the corresponding code.

Figure, add multiple numbers in a column. Click Insert. Name 2

Enter a custom name (e.g., GS) in the box under Name in the current workbook, =Evaluate (A1) in the box under Reference Location, and click Add. Okay, let's go. 3.

Enter "=GS" in cell B1 to get the result of cell A1 formula (1 to 2. Move the mouse to the lower right corner of cell b1 and the cursor changes to the black cross. Hold down the left mouse button and drag it down to B4 to get the corresponding result.

1.Open Excel**Wang, select a blank cell, enter sum, and double-click sum in the comma box that pops up.

2.After selecting the cells of the requirements and brother pins, press the enter key and you are done.

Because you're looking for a number, you have to enter the function to find the number to figure out how many numbers there are.

Press Ctrl with your left hand and click on the cell you want to sum with your right hand: =sum(a1,a3,a6,a8,a10). As shown in the figure, a1, a3, a6, a8, and a10 participated in the summation.

Method:

2. In the first step, enter = in the sum column"z="&c2, and then double-click Quick Fill.

3. Create an auxiliary column, and copy and paste the data of the summing column as a numeric value.

4. Use the data of the selected auxiliary column and use the shortcut key Ctrl+H to retrieve the replacement box.

5. The key step is to enter the unknown number in the search content, here is z and then click Replace All.

What symbols do you use to separate them.

1. Use first"+"Replace all the delimiters.

Define the name, type =evaluate(a1) in the reference position, set the name to "answer", and enter the formula = answer in the right cell (e.g. b1).

It is suggested that it is best to divide the columns first, and divide the columns by spaces, so that you can put multiple values into multiple cells, and then sum, or there are multiple values in a cell that are text states, which cannot be summed. Hope it helps.

Select multiple cells and use the auto-sum feature to reach your goal.

I can't ask for it, so I can only list it separately.

Detailed steps:

Operating Equipment: Dell Computer.

Operating system: win10

Operating software: excel

1. For example, the number of rolling macros of the same model in the following ** is combined and summed. First, select all the models in column A.

2. Copy and paste the data of column A into the blank column E, and then click "Data" and "Remove Duplicates".

3. Select column E in the pop-up window, and click "Delete Duplicates" to prompt the window to click OK.

4. Enter the formula =sumif(A2:A28,E1,B2:B28) in cell F1.

5. =sumif($a$2:$a$28,e1,$b$2:$b$28), add "$" enter before the sign of the cell range and summing area to sum the duplicates. Big Silver Book.

6. Fill the formula under the F2 cell, and then the other models can be summed, as shown in the red box below, and all duplicates are combined and summed.

Hello! Summing data in the same cell is very simple, as follows: