Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need a formula for to calculate a total value of rowwise
example i find the value of A1+D1+g1 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
rowwise query | Excel Worksheet Functions | |||
rowwise total! | Excel Worksheet Functions |