SUM column with 2 criteria, when 1 criteria is met return value from adjacent cell

[BarryAllen]

Have a worksheet with multiple column data sets. column "A" has dates, column "E" has Abbreviations for names of products, column "H" has numerical values. Cell "B2" has a numerical value & Cell "A2" has a text value. Cells B2 & A2 are criteria.

A2 = WF
B2 = 51,737

I need to sum column "H" where column "E" contains WF, summation of column H stops when value in B2 is met. Then I need to know the adjacent value from column "A" (date).

Can anyone help me with the formula to achieve this??

 

[Joe4]

There are a few details that we need to know/understand to make sure we fully understand what your data looks like and what you are trying to do with it.
Can you post an example of your data for us, along with the expected result from that data set? I think that should clarify any lingering questions.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.