Hi,
I have a column that's counting or summing languages, such as English, Spanish speakers
Trying to figure out "other languages & count or sum up as with the English & Spanish speaker by using:
=COUNTIFS($H$24:$H$173,"<>*English*",$H$24:$H$173,"<>*Spanish*")
Problem with this function is that it's also counting Blank cells
How to modify function to ignore blanks
Thanks
Bookmarks