There are total 9 SPARTAN-IIs alive.
John, Maria, Dante, Fred, Linda + 3 in cole protocol + 1 I don't really remember...
A lot of them died in Reach.
The 3 Spartans in Halo Wars are a setting breaker. They don't match with any of the other settings, so you shouldn't count them(the same thing...