Problem. Description. 0 (Zero) is shown instead of the expected result. Make sure Criteria1,2 are in quotation marks if you are testing for text values, like a person's name.. The result is incorrect when Sum_range has TRUE or FALSE values.. TRUE and FALSE values for Sum_range are evaluated differently, which may cause unexpected results when they're added. ...

Download our Formulas tutorial workbook. We've put together a Get started with Formulas workbook that you can download. If you’re new to Excel, or even if you have some experience with it, you can walk through Excel’s most common formulas in this tour.

USB-C overview. With a USB-C connection, you can charge your Windows 11 PC, and you can also connect to other USB Type-C devices such as mobile phones, docking stations, display adapters, and other devices that have a USB-C port.

We want to hear from you! Please continue to share your feedback with us — either in the Google Play Store, directly in the Phone Link and Link to Windows apps, or at the bottom of this article.

Take a picture of some printed data Maybe you’d like to get data from your previous tax returns into Excel and you only have printed copies.Just take a picture of each one, transfer the pictures to your computer (OneDrive is great for this). Then, click Data > From Picture > Picture From File and follow the on-screen instructions to convert picture to data.

When you initially setup your Windows device, you might have opted to use a local account instead of a Microsoft account. The main difference between a local account and a Microsoft account is that a local account is specific to one device, while a Microsoft account can be used across multiple devices and Microsoft services.

Learn how to locate, install, and share files with custom fonts compatible with Microsoft Office applications.

Microsoft's products and services work best if you use the same language and region across all your devices, and in all of your app and Store settings.

Find and download free templates to create documents like calendars, business cards, letters, greeting cards, brochures, newsletters, or resumes.

Lithium-ion batteries wear out over time, which can result in a battery not holding a charge for as long as it did when it was new. Keeping the battery charged to 100% all the time can cause it to deteriorate faster.