Good morning Martin Short

This can be done using the old chestnut, =SUMIF().

Let's say that the example above occupies range A1 to A7. The formula
in, say, A( should be:

=SUMIF(A1:A7,"<=45",A1:A7)

giving a result of 125.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=383821