The SUMPRODUCT function returns the sum of the products of corresponding ranges or arrays.The default operation is multiplication, but addition, subtraction, and division are also possible. In this example, we'll use SUMPRODUCT to return the total sales for a given item and size:

Description. The ROUND function rounds a number to a specified number of digits. For example, if cell A1 contains 23.7825, and you want to round that value to two decimal places, you can use the following formula:

Important: You won't lose files or data by resetting OneDrive on your computer.Resetting OneDrive only disconnects all your sync connections (including personal and work or school).

Windows 10 Pro offers more advanced security and business networking features, including: BitLocker Drive Encryption

Need help with an Xbox console, an Xbox game, or Xbox network? Find out how to get in touch with us.

Sign out of your account and then sign in to your new account. If everything is fixed, move your personal data and files to the new account. To move your personal files from your old account to your new account, try opening File Explorer, expanding This PC > OSDisk (C:), and looking in the Users folder, where you should see folders for both accounts.

How to redeem a gift card, Xbox download code or token. Both Microsoft and Xbox gift cards and download codes and tokens work the same way: once redeemed to your Microsoft account, you can spend your balance at Microsoft Store online, on Windows or Xbox, and you can get downloads for the latest apps, games, movies, TV shows, and Surface, Xbox, and accessories.

Set up PC folder backup. Open OneDrive settings (select the OneDrive cloud icon in your notification area, and then select the OneDrive Help & Settings icon then Settings.). Open OneDrive settings (select the OneDrive cloud icon in your notification area, and then select the OneDrive Help and Settings icon then Settings.)

Better together tip: Manage drafts from Outlook for iOS and Outlook for Android. If you use Outlook for iOS or Outlook for Android, your drafts will automatically synchronize to your mobile device.From there, you can finish messages you've started at your computer, easily add attachments from your photos or camera, or use Office Lens to capture notes from a whiteboard in a meeting.

Billing & payments. Your dashboard is also where you can: Buy, renew, or cancel a subscription.