Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.
Fix printer connection and printing problems in Windows
Find out how to How to download and install the latest printer drivers. Find out how to set up a default printer in Windows. Find out how to view a printer queue in Windows. If you are having a problem changing your printer "offline" status, go to Troubleshooting offline printer problems.
Scan a document or picture - Microsoft Support
An app for scanning files, such as Windows Scan, available for free from Microsoft Store. The Windows Scan app can help you scan pictures or documents and save them to your PC as JPEG, bitmap, or PNG files. For more info, see Install and use a scanner in Windows.
Phone Link help & learning
See plans and pricing. Find help and support content for Microsoft Phone Link. Learn time-saving tips and explore how you can use Phone Link to stay productive.
All Products
Microsoft Edge. Microsoft Lens for Android. Microsoft Lens for iOS. Microsoft Lists. Microsoft Loop. Microsoft PC accessories. Microsoft Start. Microsoft Store & billing. Microsoft Stream.
SUMIF function - Microsoft Support
SUMIF (range, criteria, [sum_range]) The SUMIF function syntax has the following arguments: range Required. The range of cells that you want evaluated by criteria. Cells in each range must be numbers or names, arrays, or references that contain numbers. Blank and text values are ignored.
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
Transpose (rotate) data from rows to columns or vice versa
If you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa.
Applies To: Excel for Microsoft 365, Excel for the web, Excel 2021, Excel 2019, Excel 2016
COUNTIF function - Microsoft Support
COUNTIF function. Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its simplest form, COUNTIF says:
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
SUMIFS function - Microsoft Support
The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value.
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, Excel Web App
VLOOKUP function - Microsoft Support
Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
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
Create a form with Microsoft Forms - Microsoft Support
Start a new form. Go to Microsoft Forms with your Microsoft 365 school credentials, Microsoft 365 work credentials, or Microsoft account (Hotmail, Live, or Outlook.com). Note: You can also log in to Office.com, look for the Microsoft 365 icons on the left, and then select Forms. Select New Form.
Applies To: Excel for the web, OneNote for the web, OneDrive (work or school), Microsoft Forms