Hi all, I've got a range of cells(let's say A1:B7) and I'm trying to figure out how to lookup a certain cell and then add all the values below.
Eg. Upon entering the search value D, all the values within B5:B7 get added.
Please refer to the image attached and thank you in advance!
Eg. Upon entering the search value D, all the values within B5:B7 get added.
Please refer to the image attached and thank you in advance!