Forum Discussion
Countif problem with testing for non-blank cells
I've created a COUNTIF function to summarise data from a table, where one of the criteria I want to use is whether a particular cell is empty. Ideally, I wanted to use the ISBLANK function but I coul...
Now it is counting the cells with dates in but skipping the ones with text, so the opposite of my previous problem.
Because of data input errors, which I have to live with.
I think what I will do is add the result of the countif using "*" and the result of the countif using ">0", which should capture both data types.