ExcelBanter - I need a formula for rowwise

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - I need a formula for rowwise (https://www.excelbanter.com/excel-worksheet-functions/183751-i-need-formula-rowwise.html)

Excel function

I need a formula for rowwise

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

yshridhar

I need a formula for rowwise

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

"Excel function" wrote:

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

Gary''s Student

I need a formula for rowwise

In A2 enter:
=A1+D1+G1
--
Gary''s Student - gsnu200779

"Excel function" wrote:

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

All times are GMT +1. The time now is 09:18 PM.