Hi,

Try this

=MIN(1000,SUM(A1:A20))

Mike

"Terri" wrote:

This may be very basic, but I have a column that I need to sum, but if the
total is over 1000, it only shows 1000. Any clues as to how to accomplish
this?