Excel Tips - Tip 14 (Using IF Command with COUNTIF Formulae)

Hello,

After all the appreciation and positive feedback, I am pleased to continue my tips.

Here is the Fourteenth tip for you. Hope this help you.

Using IF Command with COUNTIF Formulae is very easy and effective.

Points to remember while using IF Command with COUNTIF()

1. IF Command is used for the outcome in True or False.

2. Gives command for “True” value and “False” Value without Double quote i.e. (“)

3. COUNTIF() counts values based on a single criteria and COUNTIFS() Count values based on a Multiple criteria.

4. Criteria could be a number, expression, cell reference, text, or a formula

5. Criteria which are text or mathematical/logical symbols (such as =, +,-, /,*) should be in double quotes i.e. (“”)

In case of any query feel free to contact me any time. If any of your friends is also interested for the said excel Tips, then asked them to fill the form by clicking on the below mentioned link:

https://docs.google.com/forms/d/12T8v5XY0XlF9IhuCZPQpydd8hjCtrW7hZs9_GiOffIw/viewform?c=0&w=1

If you have something that you want to share with the group, please write to excelms.tips@gmail.com

Please do share your valuable feedback. Keep Sharing.

Thanks & Regards,

CA Mohit Bansal

Excel Enthusiast

 +91-9045773456