Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

referencing a name range in Excel

Status
Not open for further replies.
dmccallum

dmccallum

Programmer
Jan 5, 2001
90
US
On a sheet labeled April I have a range of cells named April_130 and so on for other months. I want to have a sheet labeled All 130s and have those month_130 ranges appear on that sheet. I can see how to sum the amounts but not to display them all.
 
Sort by date Sort by votes
can't you just use a regular cell formula to display the sum of the ranges?
 
Upvote 0 Downvote
There are five columns and an undetermined number of rows. So it would be tedious at best.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Question
scrping in listbox in a web page
Replies
0
Views
197
sal21
sal21
M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
292
mintjulep
M
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
328
SkipVought
S
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
564
remeng
remeng
remeng
  • Locked
  • Question
Multiple Users in a Macro enabled Excel Doc
Replies
0
Views
145
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top