COUNTA function
Excel » Functions » Statistical » COUNTA function »
How to use the COUNTA function
The COUNTA function counts the non-empty or blank cells in a cell reference. The picture above demonstrates the COUNTA function […]
How to use the COUNTIF function to count not blank cells
The COUNTIF function is very capable of counting non-empty values. Column B above have a few blank cells, they are […]
A dynamic named range grows automatically when new values are added and also shrinks if values are deleted. This saves […]
How to create a dynamic pivot table and refresh automatically
This article shows you how to refresh a pivot table automatically using a small VBA macro. If you add or delete […]
Create a drop down list containing alphabetically sorted values
This article describes how to create a drop-down list populated with sorted values from A to Z. The sorted list […]
Create dependent drop down lists containing unique distinct values
This article explains how to build dependent drop down lists. Here is a list of order numbers and products. We […]
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]