I need a formula for rowwise

Excel function · Apr 15, 2008

I need a formula for to calculate a total value of rowwise
example i find the value of A1+D1+g1

yshridhar · Apr 15, 2008

Try this
=SUMPRODUCT(--(MOD(COLUMN(A1:Z1),3)=1),A1:Z1)
best wishes
Sreedhar

Gary''s Student · Apr 15, 2008

In A2 enter:
=A1+D1+G1