Count numbers or dates based on a condition - Microsoft Support
Count numbers or dates based on a condition. To count numbers or dates that meet a single condition (such as equal to, greater than, less than, greater than or equal to, or less than or equal to), use the COUNTIF function.
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.
Use the SUM function to sum numbers in a range
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.
Calculation operators and precedence in Excel - Microsoft Support
Operators specify the type of calculation that you want to perform on elements in a formula—such as addition, subtraction, multiplication, or division. In this article, you'll learn the default order in which operators act upon the elements in a calculation.
Add or subtract dates - Microsoft Support
Let’s say your account has a 30-day billing cycle, and you want to have the funds in your account 15 days before the March 2013 billing date. Here’s how you would do that, using a formula or function to work with dates.
Add or subtract time - Microsoft Support
Let's say that you need to add two different time values together to get a total. Or, you need to subtract one time value from another to get the total time spent working on a project. As you'll see in the sections below, Excel makes it easy to add or subtract time. Windows Web.
How to earn Microsoft Rewards points - Microsoft Support
How to earn Microsoft Rewards points. It’s easy to rack up Microsoft Rewards points and earn your way toward great rewards like gift cards, movies, games, nonprofit donations, and more. Stay signed in with your Microsoft account and you'll earn …
Change or reset your password - Microsoft Support
If you want to change or reset the password you use to sign in to Windows, you have different options. This article outlines the different approaches you can take, whether you’re using a Microsoft account or a local account, logged in or at the sign-in screen.
Recover lost or deleted files - Microsoft Support
If you can't find a file on your computer or you accidently modified or deleted a file, you can restore it from a backup (if you're using Windows backup) or you can try to restore it from a previous version. Previous versions are copies of files and folders that Windows automatically saves as part of a restore point.
How to redeem Microsoft Rewards points - Microsoft Support
Sign in to your Microsoft account, and see Shop & Earn History. Note that Microsoft Rewards points will expire if you don't earn or redeem anything in 18 months. Learn how to redeem your Microsoft Rewards points for a huge variety of great products and sweepstakes.
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.