Forum Discussion
Not able to fix Zero-length String in Formula
Hi, I'm using a formula that is trying to calculate the total number of items (or tickets) using COUNTIFS from a table based on 3 different criteria. However, the criteria for column W which is look...
As variant with third criteria it could be used something like =COUNTIFS(W:W,"=?*") which counts all cells which have at least one character, i.e. not blanks and not empty strings.