Jul 21 2021 11:35 AM
Is there a formula that will work to add up a column that is not numerical? For example, if you need to calculate the amount of times a cell is occupied against how many times it is not?
Jul 21 2021 11:41 AM
Solution=COUNTBLANK(A2:B5) | Counts empty cells in the range above. |
=COUNTA(A2:A7) | Counts the number of nonblank cells in cells A2 through A7. |
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
Jul 21 2021 11:41 AM
Solution=COUNTBLANK(A2:B5) | Counts empty cells in the range above. |
=COUNTA(A2:A7) | Counts the number of nonblank cells in cells A2 through A7. |
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.