SUMIF function - Microsoft Support
If you want, you can apply the criteria to one range and sum the corresponding values in a different range. For example, the formula =SUMIF(B2:B5, "John", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal "John." To sum cells based on multiple criteria, see SUMIFS function.
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
使用 SUMPRODUCT 对一个或多个数组中的对应值的乘积求和
示例. 如果要使用 SUMPRODUCT 和 创建数组公式，下面是一个 Excel 网页版 工作簿，其数据与本文中使用的不同。. 复制下表中的示例数据，然后将其粘贴进新的 Excel 工作表的 A1 单元格中。 要使公式显示结果，请选中它们，按 F2，然后按 Enter。
Applies To:
Excel 2013
ブラウザーがダウンロードを保存している場所を見つける - Microsoft サポート
ブラウザーでのダウンロードの保存先については、ブラウザーの設定を確認します。 たとえば、新しい Microsoft Edge で、[設定など] 、[設定] 、 [ダウンロード] の順に選択します。 ダウンロードしたファイルの保存先 (C:\Users\[ユーザー名]\Downloads など) が [場所] に示されます。
Microsoft 365 语言配件包 - Microsoft 支持
Microsoft 365 语言配件包. 语言包会向 Microsoft 365 添加其他显示、帮助或校对工具。. 你可以在安装 Microsoft 365 之后安装其他语言配件包。. 如果说明中称语言配件包已经进行了部分本地化，则 Microsoft 365 的某些内容仍将以你的 Microsoft 365 副本的语言显示。. 如果某种 ...
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Office for business, Office 365 Small Business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Small Business Admin, Office 365 operated by 21Vianet - Admin, Office.com
Manage your Microsoft 365 subscription or Office product
Follow the prompts to install or reinstall the desktop apps. For Microsoft 365 Family or Personal subscriptions: Select Install premium Microsoft 365 apps and follow the prompts to install or reinstall the desktop apps. On the Microsoft 365 subscription tab, select Manage. From here you can: Renew your subscription with a prepaid code or card.
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Publisher for Microsoft 365, Visio Plan 2, Excel for Microsoft 365 for Mac, Word for Microsoft 365 for Mac, Outlook for Microsoft 365 for Mac, PowerPoint for Microsoft 365 for Mac, OneNote for Microsoft 365 for Mac, Word for the web, OneNote for the web, PowerPoint for the web, Excel 2021, Word 2021, Outlook 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2021 for Mac, Word 2021 for Mac, Outlook 2021 for Mac, OneNote 2021 for Mac, Office 2021 for Mac, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2019 for Mac, Word 2019 for Mac, Outlook 2019 for Mac, PowerPoint 2019 for Mac, OneNote 2019 for Mac, Office 2019 for Mac, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Microsoft 365 admin, Outlook on the web, Word Web App, Microsoft account dashboard, New Outlook for Windows
Find the settings/tools/internet options in Microsoft Edge
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
Find your Wi-Fi network password in Windows - Microsoft Support
On another Windows PC or other device, connect to Wi-Fi as you normally would, and enter your Wi-Fi password when prompted. For more info about connecting to Wi-Fi, see Connect to a Wi-Fi network in Windows.
Office 2019、Office 2016、または Office 2013 をダウンロードしてインストールまたは再インストールする
Microsoft 365 を初めてインストールする場合は、まずいくつかのセットアップ手順を実行する必要があります。以下の詳細に関するセクションを展開してください。 ただし、Microsoft 365 を再インストールするときに、既にプロダクト キーを取得していてアカウントに Microsoft 365 を関連付けている ...
Applies To:
Office 2019, Office 2016, Office 2016 for Mac, Office 2013
在 Windows 中如何获取帮助 - Microsoft 支持
以下是查找 Windows 帮助的多种不同方法: 搜索帮助 - 在任务栏上的搜索框中输入问题或关键字，以查找应用、文件和设置并从 Web 获取帮助。
TEXT function - Microsoft Support
The TEXT function lets you change the way a number appears by applying formatting to it with format codes. It's useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols. Note: The TEXT function converts numbers to text, which may make it difficult to reference in later ...
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