Hi
I'm trying to modify the formula below, to calculate average % of the rows that match an input. So it should average the rows 6, 8, 10, 12 and 14, when the rows match my lookup values.
Right now, the formula does a sumproduct of two rows, adding them together if they matches my lookup value.Please Login or Register to view this content.
Hopefully the attached file helps explain it.
Thanks in advantage
Bookmarks