Conditional Sum in Excel that counts values above X as X

Question

In Excel, I have a column of values which I want to sum, but I want any values above 5 to only count as 5. I can do this by having another column that changes the value to 5 if it's above 5 and then summing that column

=IF(C4>5,5,C4)

Is there a way to do this with a sumif statement or some other way to avoid having a new column?

Answer 1

B1 formula is:

=SUMIF(A1:A5,"<=5")

+COUNTIF(A1:A5,">5")

*5 Fill in the blanks with the image's description.

The following is an array-entered variant:

=SUM(IF(A1:A5>5,5,A1:A5))