Forum Discussion
COUNTIFS Non-Empty Cells
Hi! I'm new to excel and want to use COUNTIFS, but I don't want it to count empty cells. My formula is like this: =COUNTIFS($C$4:$C$10001;H4;$B$4:$B$10001;G4) And it works fine when ever...
visolanki10 Hi! Thank you! I have tried to paste the formula you wrote, but I still get the same result, it still counts the empty ones. Should I add something else or could it be a locale-issue?
In order to find the count of empty cells in a CountIfs formula, the criteria should also include &""
I.e. =COUNTIFS([criteria range1],"<>"&"",[criteria range2].....)