How to find a certain cell and sum all the values below

[Ironhan]

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!

 

[Fluff]

How about

=SUM(INDEX(B1:B7,MATCH(E1,A1:A7,0)+1):B7)

 

[Ironhan]

How about

=SUM(INDEX(B1:B7,MATCH(E1,A1:A7,0)+1):B7)

Thanks Fluff precisely what I needed...
Appreciate your help!

 

[Fluff]

You're welcome & thanks for the feedback.