Hi there

Can anyone help with the following problem:

Example List
____________

23
45
62
12
8
30
7

I want to sum all of the numbers LESS THAN or EQUAL TO 45
Also to make things more difficult, I can't use filters and I don't
want to create a UDF in VBA. (The reason for the latter is that I am
convinced that this should be able to be done using a standard Excel
function!)

Any suggestions?

Thanks
Martin


--
MartinShort

Software Tester
------------------------------------------------------------------------
MartinShort's Profile: http://www.excelforum.com/member.php...o&userid=22034
View this thread: http://www.excelforum.com/showthread...hreadid=383821