![]() ![]() Do not count cells that are visibly empty Cells with formulas returning a blank result ![]() If this is an unexpected or undesired result, see below for how to resolve these issues. Therefore, only cell B7 was excluded from the COUNTA tally, bringing the total to 6 cells with data. The image above shows that cell B5 contains a formula that returned a blank cell, and cell B6 contains a space, that is a text value. The same formula, =COUNTA(B2:B8), is entered in cell D2, returning a result of 6, even though cells B5 and B6 appear to be empty. The COUNTA function will include these cells in its non-empty cell count also. ![]() ![]() It is important to remember that a cell that appears to be empty may, in fact, contain a space or a formula that gives it an appearance of being empty. There may be times when your COUNTA formula gives an unexpected result. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |