Do Excel formulas with dollar signs trip you up? If so, this video was made for you. I share how to understand and use the absolute reference and when it is time to switch to a mixed reference. I'll use the countif function to determine if someone with scores of 5 star rating has 3 or more frequencies. The video will make a lot more sense. Enjoy!