SORT function - Microsoft Support
The SORT function will return an array, which will spill if it's the final result of a formula. This means that Excel will dynamically create the appropriate sized array range when you press ENTER.If your supporting data is in an Excel Table, then the array will automatically resize as you add or remove data from your array range if you're using Structured References.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
PowerPoint help & learning
Find PowerPoint help and training from Microsoft. Get answers to your questions, and learn from how-to articles and training videos for PowerPoint.
Microsoft Support
Microsoft support is here to help you with Microsoft products. Find how-to articles, videos, and training for Microsoft Copilot, Microsoft 365, Windows, Surface, and more.
L’appareil photo ne fonctionne pas dans les Windows
Lorsque votre caméra ne fonctionne pas dans Windows 11, il est possible que des pilotes soient manquants après une mise à jour récente. Il est également possible que votre programme antivirus bloque l’appareil photo, que vos paramètres de confidentialité n’autorisent pas certaines applications à accéder à celle-ci, ou que le problème provienne de l’application que vous ...
如何更正 #VALUE! SUMIF/SUMIFS 函数中的错误 - Microsoft 支持
SUMIFS 中的范围参数必须始终相同。 这意味着 criteria_range 和 sum_range 参数应引用相同数量的行和列。 在下面的示例中，公式应返回贝尔维尤的每日苹果销售总额。 但是，sum_range (C2:C10) 参数中的行和列数量与 criteria_range (A2:A12＆B2:B12) 参数中的数量不同
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel 2013
SUMPRODUCT 函数 - Microsoft 支持
sumproduct 函数返回相应范围或数组的乘积的总和。 默认运算是乘法，但也可以加法、减法和除法。 在此示例中，我们将使用 sumproduct 返回给定项的总销售额和大小：
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
关于 Microsoft Rewards 状态级别 - Microsoft 支持
Microsoft Rewards 有两个状态层：级别 1 和级别 2。 通过每月达到 500 个 Microsoft Rewards 积分来赚取和保持级别 2 状态 - 无论你如何赚取积分，它们都计入你的状态。
Use Game Mode while gaming on your Windows device
Prevents Windows Update from performing driver installations and sending restart notifications; Helps achieve a more stable frame rate depending on the specific game and system
What controllers can I use for cloud gaming on Xbox?
Pressing the Xbox button (or Home button on some controllers) may take you to the home screen on your Android device. If your controller does not have an Xbox/Home button equivalent, you can use the on-screen touch version of the Xbox button located in the center of your game screen.; Some controllers can be used with a wired connection instead of Bluetooth.
Description of the Windows Update Standalone Installer in Windows
Describes how use Wusa.exe to install and uninstall update packages in Windows Vista, Windows Server 2008, Windows 7, Windows Server 2008 R2, Windows 8, Windows Server 2012, Windows 8.1, Windows Server 2012 R2, Windows 10, and Windows Server 2016 Technical Preview.