USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=Out()
|
|
|
=Total()
|
|
|
=ADD()
|
|
|
=Sum()
|
Detailed explanation-1: -Insert the formula: =SUMPRODUCT(–($B3:$F3=I$2), $C3:$G3) Press enter. Drag the formula right to the other cells in the row and then down to the other cells in the column by clicking and dragging the little “+” icon at the bottom-right of the cell.
Detailed explanation-2: -If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
Detailed explanation-3: -Sumif adjacent cell containing text in Excel 1. Select a blank cell, copy and paste the formula =SUMIF(B2:B7, "<>"&"", A2:A7) ( B2:B7 is the data range which contains the text cells, and A2:A7 is the data you want to sum) into the Formula Bar, then press Ctrl + Shift + Enter keys.
Detailed explanation-4: -And then press Enter key, you will get the result. Notes: (1.) If you want to sum the largest 5 values, you need to use it 5 time as this: =LARGE(A1:D10, 1)+LARGE(A1:D10, 2)+LARGE(A1:D10, 3)+LARGE(A1:D10, 4)+ LARGE(A1:D10, 5), you can expand this formula as you need.
Detailed explanation-5: -While a cell is selected, press Shift and click on another cell. All adjacent cells in between selections will be selected. This can be on a single row or column as well as a range on different rows and columns.