I need a formula for to calculate a total value of rowwise example i find the value of A1+D1+g1
E Excel function Apr 15, 2008 #1 I need a formula for to calculate a total value of rowwise example i find the value of A1+D1+g1
Y yshridhar Apr 15, 2008 #2 Try this =SUMPRODUCT(--(MOD(COLUMN(A1:Z1),3)=1),A1:Z1) best wishes Sreedhar