Excel Tips - Tip 13 (Using COUNTIF)

Hello,

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

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

Using COUNTIF Formulae is very easy and effective.

Points to remember while using COUNTIF()

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

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

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

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