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...
Try using a sum of two COUNTIFs: first is your one and second is the same with ">0" instead of "*". The 1st COUNT counts text cells and the 2nd COUNT adds date cells. This works for me.