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 Mike Lewis 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
0
0
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

M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
133
mintjulep
M
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
224
SkipVought
S
remeng
  • Locked
  • Question
Multiple Users in a Macro enabled Excel Doc
Replies
0
Views
76
remeng
remeng
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
169
huiettcm
huiettcm
IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
96
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top