Queens College Helpdesk

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

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

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

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

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

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

You can create and format a table, to visually group and analyze data. Select a cell within your data. Select Home > Format as Table. Choose...