Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

INDEX Function To Lookup Column inside COUNTIFS Function – Excel Magic Trick 1574

Posted on by Annie D

Download Excel File: https://ift.tt/2GpZGqw
In this video learn how to count the number of 4.0 grades for each test. The complication is that as we copy the formula down a column, we need the range to move to the next column. Learn how to lookup a column using the INDEX and MATCH Functions, that use that range in the COUNTIFS function. Also see two bonus formulas that use the RIGHT Function and the ROWS function.

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.