Formula for subtracting every 4th value?

[fuzzmaster]

Looking for a formula (or function) to take a starting value (X), then subtract a value (Y), and then subtract the value 4 columns to the right (Y+4), repeated 48 times. Something like this:

X-(Y)-(Y+4)-(Y+8)-(Y+12)-(Y+16)...-(Y+192)

Is there a quicker formula or function to do this rather than typing out all 48 operations?

Thanks!

 

[Aladin Akyurek]

Looking for a formula (or function) to take a starting value (X), then subtract a value (Y), and then subtract the value 4 columns to the right (Y+4), repeated 48 times. Something like this:

X-(Y)-(Y+4)-(Y+8)-(Y+12)-(Y+16)...-(Y+192)

Is there a quicker formula or function to do this rather than typing out all 48 operations?

Thanks!

Care to post a sample, mapped to a range, and the desired result for that sample.

 

[fuzzmaster]

Um...not sure what you're asking for. As an example, if you started with the value in A1, and then subtracted every 4th value to the right 48 times. e.g.:

A1-E1-I1-M1-Q1...(repeated for 48 cells)

Is that what you're looking for?

 

[Scott R]

With data in A1:GK1, try this:
=A1+SUMPRODUCT(--(MOD(COLUMN(B1:GK1)-COLUMN(A1),4)=0),B1:GK1)

 

[Aladin Akyurek]

With data in A1:GK1, try this:
=A1+SUMPRODUCT(--(MOD(COLUMN(B1:GK1)-COLUMN(A1),4)=0),B1:GK1)

Right. Replace + with -, since the OP wants to substract...

 

[fuzzmaster]

Perfect! Thanks!