If you have a number of ranges with the same dimensions, you can produce a summary range that shows the total for each position in the range using the Data / Consolidation command. It is hugely flexible, and there are a whole raft of options you can make use of depending on what you want to do.
Maybe you should experiment a bit before trying to use it. Certainly read the help on the command which is pretty comprehensive.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
