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...
Use =SUM around your different countif ranges as opposed to countifs. You're using multiple ranges but not using multiple criteria if you're only counting non-blanks
=Sum(COUNTIF(range1, "<>"&""),COUNTIF(range2, "<>"&""),COUNTIF(range3, "<>"&""))
(Sorry if the formatting is weird)