Hello,

I hope you can help. I am trying to find one cell in a column and then find another cell in the same column and then sum what is between the cells of the column. I tried the formula below however it did not work and I was hoping you could help.

=SUM(VLOOKUP(Form!H3,’Deal Scenario 1 ‘!E3:Y219,4,TRUE):VLOOKUP(Form!I3,’Deal Scenario 1 ‘!E3:Y219,4,TRUE))

Please let me know.

Best,

Sara

By: Sara