Hi
I'm trying to write a function that will look for input (exercise) in column B:B. Each exercise have two corresponding rows. One for KGs and one for Reps.
When there is a match, the function should calculate a sumproduct of the two rows with KGs and Reps.
The issue is, when there are multiple matches in column B:B my formula will only calculate the sumproduct for the first match.
Is there a way to fix this?
This formula calculates the SUMPRODUCT of my rows, but only one match.
This formula finds the rows where the input matches up with column B:B
Is it possible to combine the two above formulas, or is there a better way?
Thanks in advantage
Bookmarks