Formula question



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.





By: Sara

Leave a Reply

Your email address will not be published. Required fields are marked *