Oops-

=SUMPRODUCT(E9:Z9,--(MOD(COLUMN(E9:Z9)-2,3)=0))

"Duke Carey" wrote:

=SUMPRODUCT(C9:N9,--(MOD(COLUMN(C9:N9)-2,3)=0))

"Steve" wrote:

In cell DC9 I want to enter a formula that will give me the sum of
E9+H9+K9+N9+...(every third column in row 9). Is this possible without
having to type out =E9+H9+...?