Sum previous columns

[IluvPivots]

In search of a formula that I can populate across columns.
Right now it looks something like this:
In cell J7: =($B7*J$3)-I7-H7-G7-F7-E7-D7-C7
In cell K7: =($B7*K$3)-J7-I7-H7-G7-F7-E7-D7-C7
Every new column subtracts the sum of the columns previous to it. The number of columns will continue to grow. What can I use instead of referencing each cell?

 

[Ramballah]

In search of a formula that I can populate across columns.
Right now it looks something like this:
In cell J7: =($B7*J$3)-I7-H7-G7-F7-E7-D7-C7
In cell K7: =($B7*K$3)-J7-I7-H7-G7-F7-E7-D7-C7
Every new column subtracts the sum of the columns previous to it. The number of columns will continue to grow. What can I use instead of referencing each cell?

J7 =($B7*J$3)-sum($C$7:I7)
K7 =($B7*K$3)-sum($C$7:J7)
Now u can autofill it

 

[Fluff]

How about
=($B7*J$3)-SUM($C7:I7)

 

[gaz_chops]

Maybe

In cell K7: =($B7*K$3)-sum(C7:J7)

 

[IluvPivots]

I knew it had to be simple! Thank you Ramballah!!!!! My day is made.

 

[AlanY]

try this in J7 and copy across

=($B7*J$3)-SUM($C$7:I7)

 

[Ramballah]

So many people giving the same answer :P

 

[jtakw]

Hi,

I'll give a different one (slightly):

=$B7*J$3-SUM($C$7:I7)

Brackets not needed for the multiplication.