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...
anthwny I did not understand what do you mean by counting empty cells.
| B | C | G | H | Result |
| AAA | BBB | AAA | BBB | 2 |
| AAA | BBB | 0 | ||
=COUNTIFS($C$5:$C$10002,H4,$B$5:$B$10002,G4)
When you use the formula it will evaluate both expression as AND function ie
AND( ($C$5:$C$10002,H4), ($B$5:$B$10002,G4))
returning TRUE , TRUE then only the value starts adding up.
also it does not count the empty cells that
binodranabhat Hi! Please see attached, you see when the data is empy, it adds upp all the empty cells
