Count or Sum Ignoring Specified Text & Blanks

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

Try this...
=COUNTIFS($H$24:$H$173,"<>*English*",$H$24:$H$173,"<>*Spanish*",$H$24:$H$173,"<>")

FDibbins!!!

Works great!!

I almost had it but had 1 set of quotes too many....


Thanks again....

Happy to help and thanks for the feedback