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.