You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM (A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.

Use the XLOOKUP function to find things in a table or range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their employee ID.

Error 0x8007045D or 8007045D occurs when you download your profile or an update or launch a game or app on your Xbox. Learn what to do if you see error code 0x8007045D or 8007045D when you try to download your Xbox profile or an update to your Xbox 360 console. Learn more.

SharePoint is a browser-based app that you connect to through your web browser, like so: Go to office.com, and sign in to your work or school account. In the upper left corner of the window, select the app launcher > All apps > SharePoint.

You get the following error code and message when you try to use a game or app on your Xbox console: 0x803F9006. The person who bought this needs to sign in. This may mean we’re having trouble checking usage rights.

The Microsoft Wireless Display Adapter is a strong, reliable way to project your content, photos, and videos to a big screen. Before you begin. Identify your wireless display adapter model. Check which devices are compatible with your adapter. Set up your adapter. Connect the adapter to your display. Connect to your adapter from your Windows PC.

You see the following error codes when you try to launch a game or app on your Xbox console: 0x87e10bef. This may mean that your console needs a power cycle, or that the content is owned by another account. To resolve this error, try the solutions below.

Look up values with VLOOKUP, INDEX, or MATCH. HLOOKUP function. 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.

Find operating system info in Windows 11. To find out which version of Windows your device is running, press the Windows logo key + R, type winver in the Open box, and then select OK. Here’s how to learn more: Select Start > Settings > System > About . Open About settings.

The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH,  are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work.