EXCEL - Looking for a value in a different sheet and return sum of values from another column

Question

I have 2 different sheets, more columns. The thing is that i need to search in sheet1, column A for ex, one text. If the text is found, I need to sumif all the values from the sheet1(same sheet) from column B, and return the values to sheet2, column B.

I have tried to sumif them, but i dont know how to look for the value and if the value is found, then sumif all of them : =sumif('Sheet1'!E:E,E2,'Sheet1'!H:H)

May you please assist ? Thanks

question from:https://stackoverflow.com/questions/65896416/excel-looking-for-a-value-in-a-different-sheet-and-return-sum-of-values-from-a

Answer 1

Waitting for answers