Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I reference certain rows within array formulae? | Excel Worksheet Functions | |||
Rows to Columns on reference | Excel Worksheet Functions | |||
after selecting 50 rows of a column i can't reference the cells in the rows | New Users to Excel | |||
Reference Problem w/ inserting rows | Excel Discussion (Misc queries) | |||
How do I reference multiple rows | Excel Worksheet Functions |