its probably taken the "" as a count
if that is the case
COUNT (range) - Countif(range,"") should workaround
CountA could also be used in mix but i am not 100% sure how it could be used without data to try it on![]()
its probably taken the "" as a count
if that is the case
COUNT (range) - Countif(range,"") should workaround
CountA could also be used in mix but i am not 100% sure how it could be used without data to try it on![]()
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks