In cell DC9 I want to enter a formula that will give me the sum of
E9+H9+K9+N9+...(every third column in row 9). Is this possible without
having to type out =E9+H9+...?
In cell DC9 I want to enter a formula that will give me the sum of
E9+H9+K9+N9+...(every third column in row 9). Is this possible without
having to type out =E9+H9+...?
=SUMPRODUCT(C9:N9,--(MOD(COLUMN(C9:N9)-2,3)=0))
"Steve" wrote:
> In cell DC9 I want to enter a formula that will give me the sum of
> E9+H9+K9+N9+...(every third column in row 9). Is this possible without
> having to type out =E9+H9+...?
Oops-
=SUMPRODUCT(E9:Z9,--(MOD(COLUMN(E9:Z9)-2,3)=0))
"Duke Carey" wrote:
> =SUMPRODUCT(C9:N9,--(MOD(COLUMN(C9:N9)-2,3)=0))
>
> "Steve" wrote:
>
> > In cell DC9 I want to enter a formula that will give me the sum of
> > E9+H9+K9+N9+...(every third column in row 9). Is this possible without
> > having to type out =E9+H9+...?
try this for row 4. correct for word wrap
=SUMPRODUCT((MOD(COLUMN(E4:INDEX(4:4,100))-CELL("Col",E4)+0,3)=0)*(E4:INDEX(
4:4,100)))
--
Don Guillett
SalesAid Software
[email protected]
"Steve" <[email protected]> wrote in message
news:[email protected]...
> In cell DC9 I want to enter a formula that will give me the sum of
> E9+H9+K9+N9+...(every third column in row 9). Is this possible without
> having to type out =E9+H9+...?
Worked perfectly. Thanks...huge timesaver.
"Duke Carey" wrote:
> Oops-
>
> =SUMPRODUCT(E9:Z9,--(MOD(COLUMN(E9:Z9)-2,3)=0))
>
> "Duke Carey" wrote:
>
> > =SUMPRODUCT(C9:N9,--(MOD(COLUMN(C9:N9)-2,3)=0))
> >
> > "Steve" wrote:
> >
> > > In cell DC9 I want to enter a formula that will give me the sum of
> > > E9+H9+K9+N9+...(every third column in row 9). Is this possible without
> > > having to type out =E9+H9+...?
Nice
--
Don Guillett
SalesAid Software
[email protected]
"Duke Carey" <[email protected]> wrote in message
news:[email protected]...
> Oops-
>
> =SUMPRODUCT(E9:Z9,--(MOD(COLUMN(E9:Z9)-2,3)=0))
>
> "Duke Carey" wrote:
>
> > =SUMPRODUCT(C9:N9,--(MOD(COLUMN(C9:N9)-2,3)=0))
> >
> > "Steve" wrote:
> >
> > > In cell DC9 I want to enter a formula that will give me the sum of
> > > E9+H9+K9+N9+...(every third column in row 9). Is this possible
without
> > > having to type out =E9+H9+...?
similar question, in a column, if i want to sum up every 13th cell moving down, i.e. starting at D5, then D18, D31, etc. i tried to modify the above but am having no luck
thanks!
Try to open new thread. This thread is old as earth.
Quang PT
will do, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks