Thread: I need a formula for rowwise
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
yshridhar yshridhar is offline
external usenet poster
  
Posts: 229
Default 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
Reply With QuoteReply With Quote