Fill formulas
 

I am trying to add data every 14 rows up to a couple thousand rows. Is there
an easy way to do this?
--
radjr

Fill formulas
 

=SUMPRODUCT(--(MOD(A1:A3000,14)=1),A1:A3000)


"rob" wrote:

I am trying to add data every 14 rows up to a couple thousand rows. Is there
an easy way to do this?
--
radjr

Fill formulas
 

Perhaps you mean ..

Assuming data to be added is within B1:B141
(ie you want:=B1+B15+B29+...+B141)

In say, C1:
=SUMPRODUCT(--(MOD(ROW(A1:A141)-1,14)=0),B1:B141)

Or perhaps you were hinting at something like this ..

In any starting cell, say in E2:
=IF(MOD(ROW(A1)-1,14)=0,"Std Msg","")
Copy E2 down as far as required to insert the phrase: Std Msg
in E2, E16, E30, etc
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"rob" wrote:
I am trying to add data every 14 rows up to a couple thousand rows. Is there
an easy way to do this?
--
radjr