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...
To count non-empty cells using the COUNTIFS function in Excel, you can add additional criteria to check if the cells are not empty. You can use the "<>" operator to specify "not equal to" empty or blank cells.
=COUNTIFS($C$4:$C$10001; H4; $C$4:$C$10001; "<>"; $B$4:$B$10001; G4; $B$4:$B$10001; "<>")
=COUNTIFS($C$4:$C$10001; H4; $C$4:$C$10001; "<>"; $B$4:$B$10001; G4; $B$4:$B$10001; "<>")
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].....)
