Thread: How to add continuous 5 or 10 rows by giving number of rows to ad
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
  
Posts: 10,593
Default How to add continuous 5 or 10 rows by giving number of rows to ad
=SUM(A1:INDEX(A:A),B1)

put the number in B1

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mygrps100" wrote in message
...
I have a data set where i want to add 5 cells in a column somewhere then
subsequent 10 cells (in same column) then say 8 cells and so forth. How
can
this be done by just giving the number of contnuous cells to be added).
Like
can i say add next 5 then next 10 etc


Reply With QuoteReply With Quote