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
Windows 键盘快捷方式 - Microsoft 支持
在打开的应用之间切换 ：Alt + Tab. 打开"快速链接"菜单 ：Windows徽标键 + X. 锁定电脑： Windows 徽标键 + L. 根据你的硬件，可以使用徽标Windows + PrtScn 进行屏幕截图， 或使用Fn + Windows徽标键 + 空格键 。. 查看所有Windows 11快捷方式. 订阅 RSS 源. 了解常见键盘Windows ...
コントロールを個別に移動する、またはサイズを変更する - Microsoft サポート
レイアウトはフォームをすばやく作成および変更するのに役立ちますが、場合によっては、コントロールを個別に移動したりサイズを変更したりすることもできます。. この記事では、レイアウトからコントロールを削除する方法について説明します。. その ...
Applies To:
Access for Microsoft 365, Access 2021, Access 2019, Access 2016
Fix Bluetooth problems in Windows - Microsoft Support
Here’s how: Check in quick settings: Select the Network, Sound, or Battery icons ( ) on the right side of the taskbar, look for the Bluetooth quick setting, then select Bluetooth to turn it on. You’ll see “Not connected” if your Windows 11 device isn’t connected to any Bluetooth accessories. Check in Settings: Select Start > Settings ...
Use Microsoft Teams for work or school in Windows 11
Taskbar icon. Apps. Check your version of Teams. For Microsoft Teams (free), select Settings and more > Settings > About Teams , then look under Version to see if you have the latest version or need to Update now. For Microsoft Teams (work or school), select Settings and more > About, then look under Version.
Applies To:
Microsoft Teams, Microsoft Teams personal, Microsoft Teams small business
Mailbox storage limits in Outlook - Microsoft Support
Clean up Mailbox. From the Settings > Storage page you should see a breakdown of how much space each folder in your mailbox is taking. Below, you should see a list of the folders represented in the breakdown with the option to permanently delete all items (or those older than 3, 6, or 12 months) in these folders to free up space.
Applies To:
Outlook Web App for Office 365, Outlook Web App for Office 365 Small Business, Outlook.com, New Outlook for Windows, Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
Wordと Outlook で言語のアクセント 記号を追加するためのキーボード ショートカット - Microsoft サポート
Alt + 0362. Alt + 0363. 注: 別の数値キーボードを使用せずにノート PC で作業している場合は、Wordの [> シンボル の 挿入] > [ その他のシンボル] コマンドを使用して、ほとんどのアクセント付き文字を追加できます。. 詳細については、「 Wordにシンボルを挿入する ...
Applies To:
Word for Microsoft 365, Outlook for Microsoft 365, Word 2021, Outlook 2021, Word 2019, Outlook 2019, Word 2016, Outlook 2016
Use Smart charging in Windows - Microsoft Support
When Smart charging is on, you’ll see a heart on the Battery icon in the following places—on the right side of the taskbar and in Power & battery settings. When your hover over the Battery icon with your mouse, it says “Fully Smart charged” and means the battery isn’t charging even though your device is still plugged in.
Excel video training - Microsoft Support
Templates. A list of Excel training, from entry level to advanced skills, plus templates and other resources.
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 2016
Aktualisieren auf den neuen Microsoft Edge - Microsoft-Support
Herunterladen und Installieren des neuen Microsoft Edge. Stellen Sie sicher, dass Sie über Administratorrechte auf Ihrem Gerät verfügen, und gehen Sie folgendermaßen vor: Wechseln Sie zur Microsoft Edge-Webseite, um Microsoft Edge auf Ihrem Windows-, macOS-, iOS- oder Android-Gerät herunterzuladen und zu installieren.