Thread: Fill formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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
Reply With QuoteReply With Quote