How to calculate the sum of multiple cells?

Question

excel

good afternoon!
you need to calculate the sum of several cells but there is a ceiling.
those. if A5 = 1100 then outputs 1000

A1 500
A2 200
A3 300
A4 100
A5 = 1000

Answer 1

A6 \u003d SUM (A1: A5) It is
not clear about the ceiling)

Answer 2

if I understand you correctly about the "ceiling", then you need to have "1000" indicated in the cell when the amount exceeds 1000. Then =IF(SUM(A1:A5)>1000,1000,SUM(A1:A5))