Sum after filtration data with criteria

Hi,

I had attached a sample file, were I want a result of sum of amount marked in red.
i.e. if I filter the data with column j, and then I want to sum the amount against the dealer's and the result should display in f3:h8 in respective cells.

For example, I had filter R3 from route column and I should get the result in F3:H8 as shown in red.

Hi,

Vlady & reimar_rem ,



Thanks for the formula which works perfect as I need.

But can u explain how it works.

Thanks & regards,

Mahesh