Medgar Evers College of CUNY

 The SUM function, one of the math and trig functions, adds values. You can add individual values, cell references or ranges or a mix of all three. For ex...

Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular ci...

The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF...

Use the IFS function to check whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. Select the ce...

Use the SUMIF function to sum the values in a range that meet criteria that you specify. Select a cell. Type =SUMIF(. Click and drag the c...

Use SUMIFS to test multiple conditions and return a value based on those conditions. For example, you could use SUMIFS to sum the number of a products sold ...

Unlike other Microsoft Office programs, Excel does not provide a button to number data automatically. But, you can easily add sequential numbers to rows o...

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

By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Onc...

You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function. Combine data with the Ampersand s...