Hello all and thanks in advance. In Column W, I want excel to take the date in column R and find it in column G. Then, I want it to average all of the numbers that are found in column K. I've looked online using Google but have found no answers. Not sure if I need to use an "IF(Vlookup), SUMPRODUCT or something else.

Thanks!

Best,
LouisSumproduct.PNG