Excel sum named range

[dmccallum]

One several sheets I have a range of six columns and various rows named April_130, May_130, etc. I need to copy that range to another sheet intact which I'm able to do. But I also need to create a summary of all 130s by month so I need to be able to sum the sixth column range April_130.

How?

 

[Dreamboat]

Create another named range--I'm certain they can overlap. Just name that range TotalApril_130 or TApril_130 or whatever.
techsupportgirl@home.com

http://www.WeDoManuals.com

Brainbench MVP for Microsoft Word at

http://www.brainbench.com

 

[dmccallum]

I've done that before but I thought there would be another way.

 

[Dreamboat]

Where are you putting your sums of sums (?)? Are you putting it on a summary sheet? You can do data consolidation. Check it out in the help file.

Wow. I typed "data consolidation" (with the quotes) into yahoo and found this:

http://www.lgtraining.co.uk/speed/speed_consolidation.htm

techsupportgirl@home.com

http://www.WeDoManuals.com

Brainbench MVP for Microsoft Word at

http://www.brainbench.com

 

[dmccallum]

On the summary sheet I use the following formula:

{=+IF(ISERROR(April_130),0,SUM(April_130))}

which totals the range of amounts for the month of April but only because I have the specific column I need totaled as the range. I want to be able to include the description, date, etc. in the same range name (April_130) and not have overlapping with additional range names.

I'm looking at the data consolidation page you referred to now to see if I should redo the above formula.