Countifs

[psrawat]

I have a excel data containing than 10000 rows in which world's continents name are listed in column "A", countries name in column "B", cities name in column "C" and growth rates in Column "D". Now issue is whenever I try to count the number of cities that come under "India", under "Asia continent" and their growth rates are more than or less than 8%, I get zero in answer or incorrect figure and sometime error.

Please help me with this

 

[Aladin Akyurek]

Something like:

=COUNTIFS(A:A,"asia",B:B,"india",D:D,"<="&0.08)

even just:

=COUNTIFS(B:B,"india",D:D,"<="&0.08)