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
Sort by dates - Microsoft Support
When dates in a worksheet aren't in the order you want, you can sort them. For example, you can sort them from oldest on top to newest on top. Here's how to sort unsorted dates: Drag down the column to select the dates you want to sort.
Applies To: Excel 2013
Join a meeting without an account in Microsoft Teams
If you don't have an account, follow these steps to join. If you're having trouble joining a Teams meeting, try I can't join a Teams meeting . Note: For some meetings, admin settings prevent people who are not signed in from joining the meeting.
Applies To: Microsoft Teams
Find your IP address in Windows - Microsoft Support
For Wi-Fi connection. Select Start > Settings > Network & internet > Wi-Fi and then select the Wi-Fi network you're connected to.
Hide or Unhide worksheets - Microsoft Support
If you don't see the tab that you want, click the scrolling buttons to the left of the sheet tabs to display the tab, and then click the tab. Two or more adjacent sheets. Click the tab for the first sheet. Then hold down Shift while you click the tab for the last sheet that you want to select. Two or more nonadjacent sheets
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
How to check if your email address is a Microsoft account
If you don't have a Microsoft account, or you want to create a new one, you can follow these steps: Go to the Microsoft account sign-up page and click on Create account. Enter your preferred email address, or click on Get a new email address to get a new one from Microsoft. You can choose from @outlook.com or @hotmail.com domains.
Applies To: Microsoft account dashboard
Change or reset your password - Microsoft Support
Important: Microsoft accounts, the Windows operating system, and other Microsoft products include passwords to help secure your information.This article provides some options that you can use to reset or recover your password if you forget it. Be aware that, if these options don’t work, Microsoft support can't help you retrieve or circumvent a lost or forgotten password.
Block or allow (junk email settings) - Microsoft Support
Use the Block or Allow settings to help control unwanted and unsolicited email messages by creating and managing lists of email addresses and domains that you trust and those that you don’t. This article is for Outlook Web App, which is used by organizations that manage email servers running Exchange Server 2013 or 2010.
Applies To: Outlook on the web for Exchange Server 2016, Outlook on the web for Exchange Server 2019, Outlook Web App
Work with documents in Word for the web - Microsoft Support
Note: If you can't edit the name, you're probably in Reading View. Select Edit Document > Edit in Browser. Open a document. Select File > Open, and select the document you want. If you're working offline, your revisions will be saved the next time you connect online. Rename a document.
Applies To: Word for the web
Install Windows 7 Service Pack 1 (SP1) - Microsoft Support
If your PC isn’t able to find or install updates, the Windows Update troubleshooter might be able to fix the problem. Select the Start button, and then select Control Panel. In the search box, enter troubleshooter and then select Troubleshooting from the list of results.