(I've been told that my previous post was confusing, so I'll try
again.)
Suppose I have 2 columns, one contains odd numbers, the other even
numbers. They are named ranges "Odd" and "Even", respectively.
A B C
1 Odd Even
2 1 2
3 3 4
4 5 6
5 7 8
I want to create a formula in cell C3 which adds the contents of B3 to
A2, but which uses the range names instead of B3 and A2. I can do this
if I'm trying to add values from the same row. For example, instead of
B3 to A3 I can use Odd + Even. But I don't see how to do this for
cells in different rows, eg, B3 + A2.
I hope this is clear.
Thanks,
Jim
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
