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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I define more than one named range in a formula (RevStart:RevEnd +
LabStart:LabEnd)
 
Hi
not really sure what you're trying to achieve. Could you provide some
more detail?
 
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.
 
You must log in or register to reply here.

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

Set non-continuous PrintArea via Function / Name 0
How do I have a cell value define a dynamic named range? 15
Changing Defined Names 2
Add sheet name into a variable. 1
Deifine range ignoring duplicates 3
SUMPRODUCT Issue 5
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6
Question on Named range with formula 2

Back
Top