🔺 While inputting text data as the argument, make sure you’re using Double-Quotes (“ “) outside the text string. 🔺 If the count of the cells seems confusing or wrong, then please check if any of your empty cells contain a space character as the COUNTA function includes a cell containing space characters while counting. 🔺 You’re allowed to input up to 255 arguments in the COUNTA function. ➤ After pressing Enter, you’ll get the return value as 8. ➤ Select Cell B16 and type any of the two from the following formulae: To count non-empty cells from the following table containing List 1 and List 2, now have a glance at the simple steps. Or, we can even select the entire range of cells containing two adjacent columns and input it to the first argument only. As we’re now dealing with two different columns, we can input these two different ranges of cells in the COUNTA function. The blank and space-contained cells have been highlighted now for the convenience of understanding the characters in the cells. Now the following table has two columns of random data. Using COUNTA for Multiple Range of Cells in Excel COUNTA function only excludes a cell where no single character is found.Ģ. So the resultant count should have been 7 instead of 8, right? The fact is, Cell B12 seems to be blank but there is a space character and that’s why the cell will not be counted as empty.
➤ Press Enter and you’ll find the total count of the non-blank cells as 8.īut there are a total of 9 cells under the List 1 header in the data chart and if you notice, B8 and B12 are blank cells.
0 kommentar(er)
