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.
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
Calculate the difference between two dates - Microsoft Support
Calculate the difference between two dates. Use the DATEDIF function when you want to calculate the difference between two dates. First put a start date in a cell, and an end date in another. Then type a formula like one of the following.
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, 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
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