I am trying to use the SUMPRODUCT function but it's new to me. The key formula is in cell E22. I am trying to sum the values in the range C6:R9 for all values that are greater than the year 2010 and less than the variable year in B21.
As it is, it will only sum the values in one row for the range C6:R6. How can I fix this?