LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I reference certain rows within array formulae? Crazy Pete Excel Worksheet Functions 11 June 13th 07 06:10 PM
Rows to Columns on reference excelmad Excel Worksheet Functions 4 January 15th 07 04:54 PM
after selecting 50 rows of a column i can't reference the cells in the rows Bob Salzer New Users to Excel 2 July 21st 06 10:29 PM
Reference Problem w/ inserting rows Paul987 Excel Discussion (Misc queries) 5 May 25th 06 10:30 AM
How do I reference multiple rows Awetronics Excel Worksheet Functions 1 November 4th 04 12:37 AM


All times are GMT +1. The time now is 04:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"