Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
NewUser13
 
Posts: n/a
Default how do i reference multiple rows/columns with one function?

I'm trying to reference multiple columns/rows on one worksheet to summarize
in another. Can I do this with one function? Can I add a row or column on
the original sheet later and have it ripple through to the other page?
  #2   Report Post  
Chris Rogers
 
Posts: n/a
Default

You can do this a number of simple ways...

Each sheet can have your data in a standard format (say for regions -
each sheet would have that regions numbers in it) and have a summary
sheet that references all of the other sheets - if they are formated
the same, it is as simple as entering the = sign in the summary cell,
and then selecting the cell in each sheet you want to add into that
cell one at a time wile pressing the + key to add them up. You only
need to build this formula once, then you can copy and paste to the
other summary areas of your summary sheet.

hth
chris

Reply
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
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 2 April 30th 23 07:42 PM
Is there a forumla to link an absolute cell reference in multiple. Thomas Excel Worksheet Functions 2 February 5th 05 05:15 PM
Cell Reference Math Ralph Howarth Excel Worksheet Functions 0 January 26th 05 07:27 PM
Incrementing rows (or columns) to a reference in another worksheet Ignobilitor Excel Worksheet Functions 2 January 20th 05 04:45 PM
How do I reference multiple rows Awetronics Excel Worksheet Functions 1 November 4th 04 01:37 AM


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

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

About Us

"It's about Microsoft Excel"