search
HomeCommon ProblemHow to sum columns in Excel
How to sum columns in ExcelMay 16, 2023 pm 03:26 PM
Cellsumspreadsheetcell referencesubtotal

How to quickly view the sum of a column in Excel

If you just want to know the sum of a column without adding that information to the spreadsheet, you can use the Excel status bar to quickly view a column or any cell The sum of the grid areas.

To see the sum of a column using the Excel status bar:

  1. Highlight the data you want to summarize. To select an entire column, click the column name. Otherwise, drag cells to select your range.
    如何在 Excel 中对列求和
  2. At the bottom of the screen, you'll see information about your selection, such as the average of all values ​​and the number of data points in the range. You will also see the sum of all values ​​in the selected cells.
    如何在 Excel 中对列求和

How to use AutoSum to sum columns in Excel

If you wish to add the sum of a column to a spreadsheet, in many cases , you can do this fastest by using the AutoSum function. This will automatically select a range of values ​​for you.

However, in some cases, such as a mix of numeric and text entries, the range it selects may not be quite right and you will need to fix it manually.

Use AutoSum to sum columns:

  1. Click the cell where you want the sum to appear. This should be in the same column as the data you are asking to sum.
    如何在 Excel 中对列求和
  2. In the Homepage toolbar, click the AutoSum button.
    • You can also use the keyboard shortcut Alt = (hold Alt and press equal sign).
      如何在 Excel 中对列求和
  3. The cells you select will be populated with a formula that includes the SUM function and a range from the same column. Cells within the range will also be highlighted.
    如何在 Excel 中对列求和
  4. When you are satisfied with the range of cells selected by AutoSum, press Enter to apply the formula. If the range isn't what you want, you can drag out a different range and press Enter.
  5. The sum of the values ​​in the column will now be displayed.
    如何在 Excel 中对列求和

How to use the SUM function to sum columns in Excel

If your data contains both values ​​and text, the AutoSum function will select that column The value below the last text value in .

You can manually create a formula using the SUM function to select your own range and ensure that you sum all values ​​in the column.

Use the SUM function to sum columns:

  1. Click the cell where you want the sum to appear. This can be any cell you choose - it doesn't have to be in the same column.
  2. Enter =SUM(
  3. Drag out the range of cells you want to include or click a column name to select the entire column.
  4. Type Close the bracket at the end and press Enter.
    如何在 Excel 中对列求和
  5. Your sum will now be calculated. If any of the selected cells contain text, these will be ignored. However , all values ​​will be included.
    如何在 Excel 中对列求和

How to sum columns in Excel using named ranges

If you are working with large amounts of data, highlight Large numbers of cells can be time-consuming. However, it is possible to apply names to specific ranges of data. You can simply reference the range in your formulas by naming it without having to select all the data each time.

Sum columns using named ranges:

  1. Highlight the data range to be named.
  2. Under the Formula menu, click Define Name.
    如何在 Excel 中对列求和
  3. Enter a name for your range and click OK.
    如何在 Excel 中对列求和
  4. Select the cell where you want the sum to appear and type =SUM( followed by the range name and the closing parenthesis. For example, =SUM(sales).
    如何在 Excel 中对列求和
  5. Press Enter key and Excel will calculate the sum of your named range.

How to use SUBTOTAL to sum a filtered column

The SUM function is not of much use if you are working with filtered data. Even if you use a data filter to display only certain values, the SUM function calculates the sum of all visible and hidden values.

If you only want to find the sum of those values ​​returned by the filter, you need to use the SUBTOTAL function.

To use the SUBTOTAL function to filter a column in Excel Sum:

  1. Highlight your cells.
  2. In the Data menu, click the Filter icon .
    如何在 Excel 中对列求和
  3. Click the filter arrow at the top of the data column.
    如何在 Excel 中对列求和
  4. Set the filter of your choice.
    如何在 Excel 中对列求和
    如何在 Excel 中对列求和
  5. Select the cells where you want the subtotal to appear.
  6. Type =SUBTOTAL(9,Then select the visible Cell . 9 is part of the function and means you are looking for the sum of the values ​​
  7. Type the final closing bracket.
    如何在 Excel 中对列求和
  8. Press Enter.
  9. Subtotal will show the correct sum of the visible values ​​in the filtered data. In contrast, using the SUM function gives you the sum of all visible cells, plus the top and bottom of your selection Any hidden cells between cells.
    如何在 Excel 中对列求和

How to sum columns using an Excel table

Although the data in the spreadsheet is in tabular form stored, but you can convert the data into an Excel table. You can quickly change the styles in the Excel table, and you can also reference them directly in formulas.

You can also use the table design tool to quickly summarize a column of data .

To sum columns using an Excel table:

  1. Highlight the data you want to convert to an Excel table.
    如何在 Excel 中对列求和
  2. Under the Insert menu, click Table.
    如何在 Excel 中对列求和
  3. Select Table.
    如何在 Excel 中对列求和
  4. Make sure the range is correct and if you include headers in the selection, make sure My table has headers is checked.
    如何在 Excel 中对列求和
  5. After creating the Excel table, Please make sure the Total Row option is selected in the Table Design menu.
    如何在 Excel 中对列求和
  6. will add a new row to the table, displaying the table The sum of the values ​​in the last column.
    如何在 Excel 中对列求和
  7. If you wish, you can click the down arrow next to the value to change it from a sum to a variety of other calculations.
    如何在 Excel 中对列求和

Become an Excel Pro

Even something as simple as summing columns in Excel has multiple ways to do it, as the above steps illustrate. Show. Although many people have only scratched the surface of Excel's capabilities, it is still a very powerful application.

The above is the detailed content of How to sum columns in Excel. For more information, please follow other related articles on the PHP Chinese website!

Statement
This article is reproduced at:云东方. If there is any infringement, please contact admin@php.cn delete
Excel 发现一个或多个公式引用存在问题:如何修复Excel 发现一个或多个公式引用存在问题:如何修复Apr 17, 2023 pm 06:58 PM

使用错误检查工具使用Excel电子表格查找错误的最快方法之一是使用错误检查工具。如果该工具发现任何错误,您可以更正它们并再次尝试保存文件。但是,该工具可能无法找到所有类型的错误。如果错误检查工具没有发现任何错误或修复它们不能解决问题,那么您需要尝试以下其他修复之一。要在Excel中使用错误检查工具:选择公式 选项卡。单击错误检查 工具。在发现错误时,有关错误原因的信息将出现在工具中。如果不需要,请修复错误或删除导致问题的公式。在错误检查工具中,单击下一步以查看下一个错误并重复该过程。当没

如何解决在Microsoft Excel中出现内存不足的问题?如何解决在Microsoft Excel中出现内存不足的问题?Apr 22, 2023 am 10:04 AM

MicrosoftExcel是一种流行的程序,用于创建工作表、数据输入操作、创建图形和图表等。它可以帮助用户组织他们的数据并对这些数据进行分析。可以看出,所有版本的Excel应用程序都存在内存问题。许多用户报告说看到错误消息“内存不足,无法运行MicrosoftExcel。请关闭其他应用程序,然后重试。”尝试在他们的WindowsPC上打开Excel时。一旦显示此错误,用户将无法使用MSExcel,因为电子表格将无法打开。一些用户报告在打开从任何电子邮件客户端下载的Excel

如何在 Excel 中启用或禁用宏如何在 Excel 中启用或禁用宏Apr 13, 2023 pm 10:43 PM

什么是宏?宏是一组指示 Excel 执行操作或操作序列的指令。它们可以使您免于在 Excel 中执行重复性任务。以最简单的形式,您可以在 Excel 中记录一系列操作并将它们保存为宏。然后,运行您的宏将根据您的需要多次执行相同的操作序列。例如,您可能希望在文档中插入多张工作表。一次插入一个并不理想,但宏可以通过一遍又一遍地重复相同的步骤来插入任意数量的工作表。通过使用 Visu

如何在 Microsoft Excel 中显示开发人员选项卡如何在 Microsoft Excel 中显示开发人员选项卡Apr 14, 2023 pm 02:10 PM

如果您需要录制或运行宏、插入 Visual Basic 表单或 ActiveX 控件或在 MS Excel 中导入/导出 XML 文件,则需要 Excel 中的“开发人员”选项卡以便轻松访问。但是,默认情况下,此开发人员选项卡不会显示,但您可以通过在 Excel 选项中启用它来将其添加到功能区。如果您正在使用宏和 VBA 并希望从功能区轻松访问它们,请继续阅读这篇文章。在 Excel 中启用开发人员选项卡的步骤1. 启动MS Excel应用程序。右键单击顶部功能区选项卡之一的任意位置,然后在出现

在 Excel 中如何查找并删除合并单元格在 Excel 中如何查找并删除合并单元格Apr 20, 2023 pm 11:52 PM

如何在Windows上的Excel中查找合并的单元格在从数据中删除合并的单元格之前,您需要全部找到它们。使用Excel的查找和替换工具很容易做到这一点。在Excel中查找合并的单元格:突出显示要在其中查找合并单元格的单元格。要选择所有单元格,请单击电子表格左上角的空白区域或按Ctrl+A。单击主页选项卡。单击查找和选择图标。选择查找。单击选项按钮。在FindWhat设置的末尾,单击Format。在对齐选项卡下,单击合并单元格。它应该包含一个复选标记而不是一行。单击确定以确认格式

如何在 Windows 11 上创建自定义电源计划如何在 Windows 11 上创建自定义电源计划Apr 28, 2023 am 11:34 AM

如何在Windows11上创建自定义电源计划自定义电源计划允许您确定Windows如何对不同情况作出反应。例如,如果您希望显示器在一段时间后关闭,但又不想让它进入睡眠状态,您可以创建一个自定义计划来执行此操作。在Windows11上创建自定义电源计划:打开开始菜单并键入控制面板。从搜索结果中选择控制面板。在控制面板中,将查看方式选项更改为大图标。接下来,选择电源选项。单击电源选项菜单中的创建电源计划选项。从提供的选项中选择您要使用的基本电源计划。在底部的计划名称字段中为其指定一个描述性名

如何在 Excel 中创建随机数生成器如何在 Excel 中创建随机数生成器Apr 14, 2023 am 09:46 AM

如何使用 RANDBETWEEN 在 Excel 中生成随机数如果要生成特定范围内的随机数,RANDBETWEEN 函数是一种快速简便的方法。这允许您在您选择的任何两个值之间生成随机整数。使用 RANDBETWEEN 在 Excel 中生成随机数:单击您希望出现第一个随机数的单元格。键入=RANDBETWEEN(1,500)将“1”替换为您要生成的最低随机数,将“500”替换为

如何压缩 Excel 文件大小?如何压缩 Excel 文件大小?Apr 21, 2023 pm 03:01 PM

如何通过删除工作表来减小Excel中的文件大小在Excel中使用多个工作表可以更轻松地构建电子表格,但使用的工作表越多,文件越大。删除不需要的工作表有助于减小文件大小。在Excel中删除工作表:确保您要删除的工作表不包含其他工作表需要或引用的任何数据。右键单击屏幕底部的工作表选项卡。选择删除。该工作表将被删除-对您要删除的任何其他工作表重复这些步骤。清除数据透视表缓存Excel中的数据透视表是分析数据的好方法,但它们会对Excel文件的大小产生重大影响。这是因为,默认情况下

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
3 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Dreamweaver Mac version

Dreamweaver Mac version

Visual web development tools

Safe Exam Browser

Safe Exam Browser

Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

SAP NetWeaver Server Adapter for Eclipse

SAP NetWeaver Server Adapter for Eclipse

Integrate Eclipse with SAP NetWeaver application server.

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!