Hi,

Here is yet another approach:

=SUMIF(D1:D17,"="&MIN(D1:D17),C1:C17)
or
=SUMIF(D1:D17,"<="&MAX(D1:D17),C1:C17)

If all the cells contain number or text and no blanks or errors, then you
can use

=SUMIF(D1:D17,"<*",C1:C17)


Adjust the references to suit.

You can simplify Bob's suggestion to:

=SUMPRODUCT(--ISNUMBER(C139:C152),D139:D152)

And just in case you don't follow Biff's or Ashish's suggestions, they are
testing for numbers by seeing if the value of the cells are above a very
small number or below a very large number.