MS Excel _ Use of Count functions_ COUNT, COUNTA, COUNTIF, COUNTIFS

This video demonstrates the Use of count functions in MS excel
COUNT, COUNTA, COUNTIF, COUNTIFS
Q.1 How Many Employee?
Q.2 How Many Employee in IT?
Q.3 How Many Employee in IT and Finance?
Q.4 How Many Employee IT department in US?
Q.5 How Many Employee IT department in US and China?