How do I define more than one named range (RevStart:RevEnd + LabS.

C

Cvdh

How do I define more than one named range in a formula (RevStart:RevEnd +
LabStart:LabEnd)
 
F

Frank Kabel

Hi
not really sure what you're trying to achieve. Could you provide some
more detail?
 
R

RagDyeR

You bring up an interesting subject.

A11:A20 is named "rng1", and filled 1:10
C1 is named "rng2" and contains 50.
C20 is named "rng3" and contains 100.

=SUM(rng1:rng3)
Returns 155

=SUM(rng1:rng2)
Returns 205

Enter 100 into A1 and
=SUM(rng1:rng2)
Returns 305.

So, it really depends on *exactly* what do you want to do, as to how to
configure the syntax of your formulas, in relation to the size and placement
of your named ranges.
 

Ask a Question

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.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables. 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
How do I have a cell value define a dynamic named range? 15
Define minimum function 0
Excel does not accept text format! 0
Changing Defined Names 2
How to open multiple instances of Word 365? 5
Reference to a Defined Name in another Workbook 1

Top