WHAT IS THIS?!? Well, let's see...
I use this formula as the value for a named range on a spreadsheet that is nothing but formulas that are pulling data together from a "Raw Data" spreadsheet.
The formula essentially looks within the range I1:I1000 and defines the range that represents all cells with data in them, or are not equal to "" or blank.
Let's break it down by each formula used:
- =Offset(reference, rows, cols, [height], [width]) - Straight from the formula description: "Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference returned can be a single cell or a range of cells."
- =Counta(value1, value2...) - Used to count the number of cells within a range that contain text/formulas
- =Countif(range, criteria) - a conditional statement that allows you to count the number of cells that meet a single criteria that you've specified.