Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

选择要求和的列，然后从下拉列表中选择一个选项。 在本例中，我们对每个列应用了 SUM 函数： 可看到 Excel 创建了以下公式：=SUBTOTAL(109,[Midwest])。 这是 SUM 的 SUBTOTAL 函数，也是结构化引用公式，只有 Excel 表格才有。 深入了解对 Excel 表格使用结构化引用。

A bookmark in Word marks a place that you want to find again easily. You can enter as many bookmarks as you want in your document or Outlook message, and give each one a unique name so they’re easy to identify.

Learn how to download, install, and configure Language Accessory Packs for Microsoft 365 for additional display, help, and proofing tools.

=sum(choose(2,a1:a10,b1:b10,c1:c10)) 相当于： =sum(b1:b10) 然后基于区域 b1:b10 中的数值返回值。 先计算 choose 函数，返回引用 b1:b10。 然后使用 b1:b10（choose 函数的结果）作为其参数来计算 sum 函数。 示例. 复制下表中的示例数据，然后将其粘贴进新的 excel 工作表的 a1 单元 ...

Screen time limits in Microsoft Family Safety are a great way to balance online habits within your family group. You decide when and for how long family members can use their connected Windows, Xbox and mobile devices.

Note: Before selecting New, consider selecting the check box for "Prompt a profile to be used."If this is enabled, you will get a prompt every time you start Outlook to pick which profile you want to open. This is helpful when you have multiple profiles and need to switch between them.

查阅值和源数据是不同数据类型。 例如，你尝试让 VLOOKUP 引用数字，但源数据却存储为文本。 解决方案：确保数据类型相同。可通过选择单元格或单元格范围查看单元格格式，然后右键单击并选择“格式化单元格”>“数字”（或按 Ctrl+1），如有需要，可更改数字格式。

了解隐式交集运算符 (@) ，该运算符使用称为隐式交集的逻辑返回单个值。 隐式交集运算符 (@) 可能会返回值、单个单元格区域或错误。 隐式交集运算符 (@) 位于称为动态数组的函数类中。

Learn how to tell if your Office software is genuine. To help determine if your Microsoft software is genuine, go to our How to Tell site for more information. Here you'll learn about authentic packaging, including what to look for with product key labels, and Certificate of Authenticity (COA), how to report counterfeit software, and find out what your shopping and licensing options are.