Sum a series of cells, but only count up to 2 in each cell

Hi,

I have a series of cells, let's say A1:C10. Each cell reads between 1 and 5. I have two needs for the cells. I need the individual cells to be able to count up to 5, however I want the totals column in column D to only total up to 2 for each cell. So in D1, the formula needs to sum for A1:C1, but only to a maximum of 6, split to a maximum of 2 for A1, B1, and C1. However I need A1, B1, and C1 to be able to read any number.

Thanks in advance for any help.

Try

=SUM(COUNTIF(A1:C1,{">0",">1"}))