China Naming Network - Ziwei Dou Shu - Lhl naming
Lhl naming
=countif(D 1:D 100," & gt= 90 ")+countif(e 1:e 100," & gt= 80 ")-count ifs(d 1:d 100," & gt=90 ",E 1:E 100," >=80")
The answer upstairs is wrong.
If a person meets two conditions at the same time, count one more person.