OFFSET Function Dynamic Range inside COUNTIFS Function – Excel Magic Trick 1573

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 create a Dynamic Range using the COUNTIFS function.

View on YouTube