Is there any way I can use the sumproduct formula with the autofilter? I
have a number of different employees and I would like to calculate weighted
averages by employees using the sumproduct formula. However, I am having
trouble finding a way to calculate the sumproduct formula by employee. Even
with the autofilter on, the sumproduct formula uses the entire data set.

If someone could help, I would greatly appreicate it.

Thanks,
Mike