Exclude rows from SUM based on the row returned from another column

Hello,

I’m new with Excel and am struggling to figure out how to do the following:

I would like to SUM the values in Column B, but exclude any rows that correspond with where the N number of largest values in column D are found.
For example I want to search column D, find the rows where the two largest values are, and exclude those rows from the SUM in column B.

Any help is greatly appreciated. Thank you.

sailepaty, the same could be achieved with a standard SUMIF as I see it, no ?

=SUMIF(D2:D10,"<"&LARGE(D2:D10,2),B2:B10)

Of course it's not clear as to what should happen if there were multiple instances of the 2nd largest value within the data set....eg:

Please Login or Register  to view this content.

what would be the expected result - 21 (all instances associated with 6 are discounted) or 28/30 (either or is discounted - first/last) ?