## Formula in Excel 2010

### How to count cells by criteria

Use

**COUNTIF**if you need to sum values for a particular person or other criterion.### How to sum cells by criteria

Use

**SUMIF**if you need to sum values for a particular person or other criterion.### Hide formulas from appearing in the edit bar

Usually you can view a formula in the Excel cell when cell is selected, but you can protect spreadsheet to
hide formulas in some cells.

### Calculating the difference between two time stamps

Because time stamps are represented as serial numbers, you can subtract the earlier time from the later time
to get the difference.

### Using Solver

Solver tool allows you to specify multiple adjustable cells and constraints on the values that the
adjustable cells can have, generate a solution that maximizes or minimizes a particular worksheet cell,
generate multiple solutions to a problem.

### Goal Seeking

Goal seeking is a useful feature that works in conjunction with your formulas. If you know what a formula
result should be, Excel can tell you which values of one or more input cells you need to produce that
result.

### How to generate series of dates

Often you'll want to insert a series of dates into a worksheet. The most efficient way to enter a series of
dates doesn't require any formulas - just use Excel's

**AutoFill**feature.### Calculating the number of work days between two dates

When calculating the difference between two dates, you may want to exclude weekends and holidays.

### Calculating the number of days between two dates

A common type of date calculation determines the number of days between two dates.

### How to insert functions into formulas

The easiest way to enter a function into a formula is to use the Excel program's

**Insert Function**dialog box.