Formula in Excel 365 2016 2010 2007 2003

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.

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.

Counting the number of unique values

You can easily count the number of unique values of the range using a simple formula.

Excel Formula auditing tools

If you would like to better understand how some of these complex array formulas work, consider using a handy tool - Formula Evaluator:

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more