NBVC
Thanks for the formula. It works fine for the columns I attatched in the earlier post but then I copied & pasted it to a different spread sheet, changed the data ranges and manually checked the result. For some reason it came out incorrect. Have I made a mistake during the movement of the formula?

=SUMIF(B79:B114,"<="&ROUND(C5,0))+COUNTIF(B79:B114,">"&ROUND(C5,0))*ROUND(C5,0)

For simplicity the rounded version is fine.


Alex G