=sum formula using arrays

[John]

Column A contains numbers, such as:
6,000
9,000
8,000

I want to sum column A, but if a number is greater than 7,000, I only want
7,000 included in my sum. The result of the above amounts I am looking for
is 20,000. I think I need an array formula, but not sure what the formula
is. Thanks

 

[Frank Kabel]

Hi
try the following array formula
=SUM(IF(A1:A3>7000,7000,A1:A3))