sum in range that we define it

[pedjvak]

Dear All
I was attached the file and show what I want please show me the solution in my file
Thanks for your Notice

[davesexcel]

Check it out,

Please Login or Register  to view this content.

[:) Sixthsense :)]

This will target only on the data placement

In K3 Cell

=IFERROR(SUM(INDEX(D:D,MATCH(TRIM(I3),A:A,0)):INDEX(D:D,LOOKUP(TRIM(J3),A:A,ROW(A:A)))),"-")

[pedjvak]

Dear davesexcel
thanks for your answer but when I take your formula in cells it is not working and show me zero

[davesexcel]

Sixthsense makes a good point,

I forgot to mention I had to reformat Column A, as they were text not numbers.

I just typed 1 in an empty cell, right clicked=>copy, selected Column A right clicked=>PasteSpecial=>Multiply=>OK

this turned the numbers into numbers.

[YasserKhalil]

The same formula of davesexcel with a little change

Please Login or Register  to view this content.

[pedjvak]

Dear davesexcel
it is ok
thanks

[davesexcel]

This also works

Please Login or Register  to view this content.