To count numbers or dates that meet a single condition (such as equal to, greater than, less than, greater than or equal to, or less than or equal to), use the COUNTIF function. To count numbers or dates that fall within a range (such as greater than 9000 and at the same time less than 22500), you can use the COUNTIFS function. Alternately, you can use SUMPRODUCT too.

Find your files in Windows 11 using one of these methods. Search from the taskbar: Type the name of a document (or a keyword from it) into the search box on the taskbar. You'll see results for documents across your PC and OneDrive. To filter your search, you can select the Documents tab—and then your search results will only show documents.

When you delete an online-only file from your device, you delete it from your OneDrive on all devices and online. You can restore deleted files and folders from your OneDrive recycle bin on the web for up to 30 days for items stored in OneDrive personal (when you're signed in with a Microsoft account), or for up to 93 days for items stored in OneDrive for work or school or SharePoint in ...

Get help with a damaged or unreadable code. If you’re unable to read all 25 characters of your digital code, you’ll need to request a replacement code by contacting aka.ms/contactxboxsupport. When you contact support, make sure to provide the proof of purchase, the serial number, and a picture of the damaged code.

For Windows: If you are trying to co-author, check the file name of the file and make sure it is in either .xlsx, .xlsm, or .xlsb format.If the file is in another format, go to File > Save As > Browse > Save as type and choose the .xlsx, .xlsm, or .xlsb format.. For Mac: If you are trying to co-author, check the file name of the file and make sure it is in either .xlsx, .xlsm, or .xlsb format.

Windows macOS Web. Go to File > New. In the search box, type Resume or Cover Letter. Double-click the template you want to use. Replace the placeholder text with your own information. On the File menu, select New from Template. In the search box, type Resume or Cover Letter. Double-click the template you want to use.

To restore your entire OneDrive, you'll need to have Microsoft 365. Go to the OneDrive website. (Make sure you're signed in with the correct account.) If you're signed in with a personal account with a Microsoft 365 subscription, at the top of the page, select Settings > Options, and then select Restore your OneDrive from the left navigation.

Turn on your TV or projector. If you're using a Miracast dongle or adapter, make sure it's plugged in to the display. On your PC, make sure Wi-Fi is turned on. On the right side of the taskbar, select the Network icon > Cast, then select your display or wireless adapter. Follow any additional instructions on the screen.

To open the Start menu—which contains all your apps, settings, and files—you can do any of the following: On the center or left end of the taskbar, select the Start icon. Note: Your taskbar settings determine where the taskbar is located. Press the Windows logo key on your keyboard. Swipe up from the bottom center or left of your screen ...

Introduction. Consumer customers can purchase Microsoft Office 2021 for Windows and Mac and commercial customers can now purchase Microsoft Office LTSC for Windows and Mac. Office 2021 and Office LTSC 2021 are the next perpetual releases of Office. They include improvements over Microsoft Office 2019 and earlier versions of on-premises Office.