Sum offset from found range

Hi!

I want to sum the values in column E by a found value in column A
The answer of the sum must be displayed in a cell on another worksheet "NewData"

So for example:

Because the search word is "hello" the sum is E2 + E3 + E4 + E8

sumhello.png

This sum should be displayed in a cell on the other sheet

I got to this but it doesn't work. Don; t know how to sum the offsetted values. Perhaps I took a wrong turn with this

Please Login or Register  to view this content.

Hope this is clear enough. There is a sample file attached. Any help would be more than welcome!

Thanks!



note: also posted this on a dutch support forum

Do you really need VBA for it?
You can use SUMIF function, like:

Formula:

Please Login or Register  to view this content.

Check attached file.

Please Login or Register  to view this content.

replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

in that line

Possibly use an input box for the search items

Please Login or Register  to view this content.

Originally Posted by nigelog

Could use with

Please Login or Register  to view this content.

Sorry, I've missed this. Cells(1,1) or Range("A1") as nicelog wrote.