Erlandsen Data ConsultingThis workbook uses a custom function to return the count of equal values in two different ranges. The function counts matches regardless of the position in the range. You will also find a function that counts the matches according to the position in the range. Click here to download this file. Updated: 2000-08-08 & 2012-04-11 [...]
It’s possible to achieve this with the built-in COUNT() or COUNTA() function, but that can be a big task if the workbook contains many worksheets, or if you frequently add new worksheets to the workbook. To count a range from several worksheets you can use the COUNTA-function like this: =COUNTA(Sheet1:Sheet10!A1:A100) The formula above will count [...]
With the built-in COUNTA()-function it’s not possible to count cells in a range depending on each cells background color. With the custom function below you can count the cells depending on their background color: Function CountByColor(InputRange As Range, ColorRange as Range) As Long Dim cl As Range, TempCount As Long, ColorIndex As Integer ColorIndex = [...]
The custom function below counts the unique values only from a given range. This function uses the fact that a collection can only hold items with unique identifications keys. If you try to add an item with a key that already exists in the collection, an error will occur. Function CountUniqueValues(InputRange As Range) As Long [...]
In Excel you can count the content of cells that meet different criteria in several different ways. These are some of the functions that can be used: COUNT Counts the number of cells in a range that contains numeric values. COUNTA Counts the number of nonblank cells in a range. COUNTBLANK Counts the number of [...]