This article shows how to count nonblank cells in Excel by using differnt functions and built-in feature in Microsoft Excel.

You can sum cells across multiple sheets in Excel. This article presents steps for Adding single-cell values or Adding values in the range of cells.

Working with ranges in Excel is a fast and simple way to identify, define, or refer to a single cell, a range (or group) of cells, a specific or constant value, or a formula. Then you can use ...

When you link a cell in Excel to a cell from another worksheet, the cell that contains the link shows the same data as the cell from the other worksheet.

Microsoft Excel allows you to assign names to any cell range using its "Define Name" utility, assessable via the right-click menu.

The most basic example of a GETPIVOTDATA formula in Microsoft Excel is when the function is used to retrieve a grand total of ...

Excel's spill range is a product of using dynamic array functions. Learn how the spill range fulfills these functions.

By default, Microsoft Excel's cells are named by their column-row references, like A1 or B2. However, you can assign a more specific name to a cell or range of cells to improve navigation, make ...

We'll review four different ways to multiply in Excel: Simple multiplication within a cell, multiplying numbers from different cells, multiplying ranges of numbers, and multiplying each number of ...

The default active cell format in Microsoft Excel isn't all that easy to see, but you can use this easy-to-implement code solution to change that.