The COUNTA() function counts all cells that are NOT empty whereas the COUNT() function only counts the cells that have numbers in them. If you are in Excel 2007 and later you can use the COUNTA() function instead of the COUNT() function. Dynamic Ranges that Include Text and More This way, the entire column will be referenced. If you use Excel 2007 or later, just use A:A as the argument for the COUNT() function, as shown in the first dynamic example above. The range reference that you use for the COUNT() function should be large enough to hold any size list that you could have in the future so it does not need to be changed. The COUNT() function counts all cells in the range that have a number. Change A:A to whatever column contains your list of data. Then, we need to use the COUNT() function as the 4th argument for the OFFSET() function in order to figure out how big our range should be. To use the OFFSET() function to return a dynamic range we simply need to put the first cell in the range as the first argument, A2 in this case.
0 Comments
Leave a Reply. |