Question: what is the difference between if and countif in excel?
Answer: COUNTIF extends the capabilities of the basic COUNT function by allowing you to tell Excel to only COUNT items that meet a certain criteria. IF function allows you to tell Excel to Represent certain results based on the special criteria.