Prev: i downloaded a plug in and it does not show up in the ribbon
Next: Dual Y Axis in Line Plots
From: bwilde on 25 Feb 2010 09:26
i have a spread sheet and want a running total based on values in every 5th &
7th cell for the entire row.
now my formula is =A3+M3+S3+Y3+AE3+AK3-L3-R3-X3-AD3-AJ3 I want to continue
to (or redo the formula) add every 5th cell and subtract every 7th cell
without having to select each one
From: Jacob Skaria on 25 Feb 2010 09:44
Try the below...

=A3+SUMPRODUCT((MOD(COLUMN(L3:IV3),6)=1)*(L3:IV3))-
SUMPRODUCT((MOD(COLUMN(L3:IV3),6)=0)*(L3:IV3))

--
Jacob


"bwilde" wrote:

> i have a spread sheet and want a running total based on values in every 5th &
> 7th cell for the entire row.
> now my formula is =A3+M3+S3+Y3+AE3+AK3-L3-R3-X3-AD3-AJ3 I want to continue
> to (or redo the formula) add every 5th cell and subtract every 7th cell
> without having to select each one
From: bwilde on 25 Feb 2010 10:29
thanks - busy now i'll try it later or tomorrow and let you know

"Jacob Skaria" wrote:

> Try the below...
>
> =A3+SUMPRODUCT((MOD(COLUMN(L3:IV3),6)=1)*(L3:IV3))-
> SUMPRODUCT((MOD(COLUMN(L3:IV3),6)=0)*(L3:IV3))
>
> --
> Jacob
>
>
> "bwilde" wrote:
>
> > i have a spread sheet and want a running total based on values in every 5th &
> > 7th cell for the entire row.
> > now my formula is =A3+M3+S3+Y3+AE3+AK3-L3-R3-X3-AD3-AJ3 I want to continue
> > to (or redo the formula) add every 5th cell and subtract every 7th cell
> > without having to select each one
 | 
Pages: 1
Prev: i downloaded a plug in and it does not show up in the ribbon
Next: Dual Y Axis in Line Plots