SUMIF function - Microsoft Support
sum_range Optional.The actual cells to add, if you want to add cells other than those specified in the range argument. If the sum_range argument is omitted, Excel adds the cells that are specified in the range argument (the same cells to which the criteria is applied).. Sum_range should be the same size and shape as range.If it isn't, performance may suffer, and the formula will sum a range of ...
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
UNIQUE function - Microsoft Support
This allows Excel to return an array of all names. Tips: If you format the range of names as an Excel table, then the formula will automatically update when you add or remove names. If you want to sort the list of names, you can add the SORT function: =SORT (UNIQUE (B2:B12&" "&A2:A12)) Example 4. This example compares two columns and returns ...
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
Repair an Office application - Microsoft Support
Right-click the Start button (lower-left corner) and select Apps and Features on the pop-up menu. Select the Microsoft Office product you want to repair and select Modify. Note: This will repair the entire Office suite even if it's just one application you want to repair such as Word or Excel. If you have a standalone app installed, then search ...
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 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, 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 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 for home, 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, InfoPath 2013, Office 365 Germany - Enterprise, Office 365 Germany - Enterprise admin
Automatically number rows - Microsoft Support
In the first cell of the range that you want to number, type =ROW (A1). The ROW function returns the number of the row that you reference. For example, =ROW (A1) returns the number 1. Drag the fill handle across the range that you want to fill. Tip: If you don't see the fill handle, you might have to display it first.
Applies To:
Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Create an email signature from a template - Microsoft Support
After you have downloaded the template, open it in Word. Choose the signature you like, select all the elements in it, then then on the Home tab, select Copy. Open Outlook and select New Email. Paste the copied signature in the email message body. Then personalize the signature—changing the words, changing the photo or logo, and adding ...
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Create a recovery drive - Microsoft Support
Note: Recovery drives created and used on machines with the April 9, 2024 security update and the revocation policy applied may be impacted.For more, see KB5025885: How to manage the Windows Boot Manager revocations for Secure Boot changes associated with CVE-2023-24932.
Come accedere a Hotmail - Supporto tecnico Microsoft
Per ottenere supporto in Outlook.com, fare clic qui oppure selezionare Guida sulla barra dei menu e immettere la query. Se l'assistenza self-service non risolve il problema, scorrere verso il basso fino a Serve ulteriore assistenza? e selezionare Sì. Per contattare Microsoft in Outlook.com è necessario eseguire l'accesso.
Applies To:
Outlook.com
Herunterladen und Installieren der neuesten Druckertreiber
Die meisten Drucker erfordern, dass Sie den neuesten Druckertreiber installieren, damit der Drucker gut funktioniert. Wenn Sie kürzlich ein Upgrade von einer früheren Windows-Version durchgeführt haben, funktioniert Ihr Druckertreiber möglicherweise mit der vorherigen Version, aber eventuell nicht gut oder überhaupt nicht mit Windows 10.
Change screen brightness in Windows - Microsoft Support
If you don't have a desktop PC and the slider doesn't appear or work, try updating the display driver. Select Search on the taskbar, type Device Manager, and then select Device Manager from the list of results.In Device Manager, select Display adapters, then select the display adapter.Press and hold (or right-click) the display adapter name, then select Update driver and follow the instructions.
Use voice typing to talk instead of type on your PC
To Insert this. Say this ' 撇 號 . 上 標 點 . 略 縮 號 -減 號 . 連 字 號 ！ 感 歎 號 . 驚 嘆 號 # 井 字 號 $ 美 元 符 號 % 百 分 號