This class will demonstrate six examples of the mega useful COUNTIF function. This function has helped me so much over the years in accomplishing many an Excel task.
I hope this class will help you understand the versatility of the function and how it could help you even beyond its typical use.
The lessons will include using COUNTIF to count values between two dates, prevent duplicate entries, uniquely rank items and also compare lists.
This function can be combined with others to extend its power. An example in this class shows it used with VLOOKUP to return the last match in a list.
So dive into the class. I will see you there.
Get in touch if you need any assistance.