Search value in range and add results

[pezalmendra]

Hello,

I was trying to build up a code similar to the LOOKUP formula but cannot manage to do it cause the answer should add all the values that matches the condition and dont know how to do it...
I have attached an example with a small table explaining better myself of what I need.

I would appreciate any help.

Many thanks!

[evertjvr]

Hi

Try this Formula in the Cell J8 Drag it to fill the range down

Please Login or Register  to view this content.

[xLJer]

There may be more involved in this solution than
a simple formula can fix. Here is the formula to
put in column J row 8.

Please Login or Register  to view this content.

and you would change the "28" to whatever your last
data row number is.

It could be that you would like to automate this further
with VBA code to make you job easier when the worksheet is
revised. Here is that code.

Please Login or Register  to view this content.

[pezalmendra]

Hi xLJer

Works really good!! I finally decided to do it with VBA cause I want to keep clean of formulas the worksheet. Actually I was trying to use your same code but without putting the formula onto the cell.
Cannot manage replace that formula into a code. The only thing I could do is to continue after that a code in which copy the values and then paste them as a value and not formula...

Maybe you know a better way...

Thanks once again!!

Regardss

[xLJer]

Here's one way to replace the formulas with values.
Add the code that I've put in red font.

Please Login or Register  to view this content.

[Leith Ross]

Hello Pezalmendra,

This macro is based on the data and layout of your posted workbook. This VBA macro may better suit your needs.

Please Login or Register  to view this content.

[pezalmendra]

Great! Thanks a lot both of you for your help.
Got now the code as I wanted!!!