![]() ![]() Column D shows what they actually contain and column E shows the character length of the content.Ĭell C5 and C9 contain a formula that returns a blank, both the COUNTIF and the COUNTA function count those cells as non-empty.Ĭell C8 has two space characters and cell C12 has one space character, column E reveals their existence by counting character length. There are blank cells in column C, shown in the picture above, that look empty but they are not. ![]() There are, however, situations where the COUNTIF and COUNTA function return unexpected results if you are not aware of how they work. ![]() COUNTIF and COUNTA function return unexpected results
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |