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. ...

If you can't sign into your Microsoft account, most issues can be identified by our sign-in helper tool. The tool will ask you to enter the email address or mobile phone number you're trying to sign in with and check the details you provide.

This article explains how you can get or create a digital signature for use in Office documents. To learn more about how to use them in Office documents, see Add or remove a digital signature in Office files.. What is a digital signature?

To keep an area of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or you can Split panes to create separate windows of the same worksheet.

Windows devices may get new functionality at different times as Microsoft delivers non-security updates, fixes, improvements, and enhancements via several servicing technologies—including controlled feature rollout (CFR).. Windows will let you know if you need to restart your device to complete an update, and you can choose a time that works best for you to complete that update.

注: パスワードがわかっていても変更したい場合は、[セキュリティ] タブ account.microsoft.com 移動し、[パスワードの変更] を選択します。 . ユーザー名とパスワードがわかっていても動作が停止している場合は、「ユーザー名とパスワードが機能しなくなった」を参照してください。

Windows Update recommends a reinstall after an update installation fails. If an update fails to install because of problems related to system files or components, you might see the following message in the Windows Update page in Settings:. Reinstall your current version of Windows to repair system files and components.

Important: you should limit the number of administrators on your Windows device because administrators have complete control over the system.Administrators can change settings, install software, and access all files. If too many people have this level of access, it could lead to security risks like malware installation or unwanted changes to your system.

Notes: If you have existing lists of safe names and addresses, you can move that information into Outlook. Click Import from File and browse for the list file that you want. To create a file that uses your current list, click Export to File and then specify where you want the new file saved.. To change a name on the list, click the name that you want to change and then click Edit.

Tasks stores tasks that you create or that are sent to you, and also messages that you’ve flagged. When you view your tasks, the default view is Flagged Items and Tasks.You can change that by selecting Tasks in the folder list to the left. For more information about tasks in Outlook Web App, go to Tasks Overview.. Create a new task by selecting New task.