View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default reference every 19 rows

The way newsgroups work is that you ask questions (and follow-up questions
if necessary), and anyone who believes that they can usefully contribute to
the discussion will answer. That way, the answer will be of benefit not
only to the original questioner but also to other readers of the newsgroup,
either now, or later through the group archives.

And if you are trying to reply to a message from Gord, make sure that you
reply to his message, rather than to your own original, and quote enough of
the previous content to put your reply into context.
--
David Biddulph

"Scottyb97" wrote in message
...
Gord Dibben .... I was wondering if there was anyway we could chat?


"Scottyb97" wrote:

trying to figure out how to write a formula the references every 19 rows.
On
my worksheet 4 I want A1 =SUM(Sheet1!A1:A19)
and I want A2 =SUM(Sheet1!A20:A38)
I want to follow this pattern for all of worksheet 4....is there a way to
not have to manually write all these equations???
thank
-Scott