Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
SUMIFS 函数 - Microsoft 支持
参数名称. 说明. Sum_range (必需). 要求和的单元格区域。 Criteria_range1 (必需). 使用 Criteria1 测试的区域。. Criteria_range1 和 Criteria1 设置用于搜索某个区域是否符合特定条件的搜索对。 一旦在该区域中找到了项,将计算 Sum_range 中的相应值的和。. Criteria1 (必需) ...
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, Excel Web App
在 Microsoft Edge 中管理 Cookie:查看、允许、阻止、删除和使用 - Microsoft 支持
在 Microsoft Edge 中管理 Cookie:查看、允许、阻止、删除和使用. Cookie 是你访问的网站存储在设备上的小块数据。. 它们有多种用途,例如记住登录凭据、站点首选项和跟踪用户行为。. 但是,出于隐私原因或解决浏览问题,你可能想要删除 Cookie。. 本文提供有关 ...
Applies To: Microsoft Edge
在 Windows 10 中修复显示模糊的应用 - Microsoft 支持
若要了解 Windows 是否可以解决该问题,请关闭在你的主显示器上显示模糊的桌面应用,然后再次打开它。 如果应用仍然显示模糊,你可以尝试为该应用使用不同的高 DPI 兼容性设置,而不是 让 Windows 尝试修复应用,使其不模糊 设置。 有关如何执行此操作的详细信息,请参阅使旧版程序与此版本的 ...
将数字设置为日期或时间 - Microsoft 支持
AM 和 PM 如果格式包含 AM 或 PM,则小时基于 12 小时制,其中“AM”或“A”表示从午夜到中午的时间,“PM”或“P”表示从中午到午夜的时间。否则,时间将采用 24 小时制。 “m”或“mm”代码必须紧接在“h”或“hh”代码之后或紧接在“ss”代码之前;否则,Excel 将显示月份而不是分钟。
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
如何更正 #VALUE! SUMIF/SUMIFS 函数中的错误 - Microsoft 支持
请参阅 SUMIF、COUNTIF 和 COUNTBLANK 函数返回“#VALUE!. ”错误 。. 解决方案: 打开公式中指示的工作簿,然后按 F9 刷新公式。. 还可通过在数组公式中结合使用 SUM 和 IF 函数来解决此问题。. 有关详细信息,请参阅文章 SUMIF、COUNTIF 和 COUNTBLANK 函数返回 #VALUE! 错误 。.
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
Windows help & learning
Find the information you need to build, run, and grow your small business with Microsoft 365. Find help and how-to articles for Windows operating systems. Get support for Windows and learn about installation, updates, privacy, security and more.
How to verify an email address in your Microsoft account
To finish the process, just follow the verification link in the email. If you need a new verification email: Sign in to Manage how you sign in to Microsoft. A Verify button will be next to any unverified aliases. Click Verify next to your email address, and then click Send email. View more Microsoft account help topics.
Applies To: Microsoft account dashboard
Open files from the File menu - Microsoft Support
Double-click Computer to get to local files, including removable flash drives. You can also select one of the locations your accounts let you get to, sign in if necessary, and then open the file you want. To add a new location, click Add a Place. Tip: If you want to bypass File > Open and always use the Open dialog box, do this: Select File ...
Applies To: Excel for Microsoft 365, Word for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, Excel 2021, Word 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Excel 2021 for Mac, Word 2021 for Mac, PowerPoint 2021 for Mac, Excel 2019, Word 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Excel 2019 for Mac, Word 2019 for Mac, PowerPoint 2019 for Mac, Excel 2016, Word 2016, PowerPoint 2016, Access 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016
Use @mentions to get someone's attention in Microsoft Teams
To get someone's attention in a channel conversation or a chat, @mention them. Just type @ before their name and then select them from the menu that appears. Note: You can also mention someone simply by typing their name. Start by capitalizing the first letter: as you continue to type the name, a list of people will appear for you to choose from.
Applies To: Microsoft Teams
Use Game Mode while gaming on your Windows device
Helps achieve a more stable frame rate depending on the specific game and system. To turn Game Mode on or off: Press the Start button , type Settings in the search box, and then select Settings. Choose Gaming > Game Mode. Turn Game Mode On or Off. Note Game Mode is turned on by default.