+ Reply to Thread
Results 1 to 3 of 3

Using Named Ranges in non-function formula

  1. 08-13-2018, 10:19 PM #1
    leaning
    leaning is offline
    Valued Forum Contributor
    Join Date
    02-26-2010
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2003/2007/2010/2016
    Posts
    432

    Exclamation Using Named Ranges in non-function formula

    Hello!
    Bill is the name of range A1:A5.
    Bob is the name of range B1:B5.
    Doug is the name of range C1:C5.

    This works: =SUM(Bill, Bob, Doug).

    Is there a syntax to use Named Ranges in non-function formulas? (something like =Bill+Bob+Doug)?

    Thanks for your help and info!

    Regards,
    leaning
    Reply With QuoteRegister To Reply
  2. 08-14-2018, 12:25 AM #2
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Using Named Ranges in non-function formula

    Quote Originally Posted by leaning View Post
    (something like =Bill+Bob+Doug)?
    In this case, it will work if the named ranges are single cell.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  3. 08-14-2018, 12:35 AM #3
    leaning
    leaning is offline
    Valued Forum Contributor
    Join Date
    02-26-2010
    Location
    Chattanooga, TN
    MS-Off Ver
    Excel 2003/2007/2010/2016
    Posts
    432

    Re: Using Named Ranges in non-function formula

    It does! Curious.

    Bill is the name of range (cell) A1.
    Bob is the name of range (cell) B1.
    Doug is the name of range (cell) C1.
    =Bill+Bob+Doug formula works.

    Hmmmmm...

    Regards,
    leaning
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Use 2 Different Named Cell Ranges To Return Values From 1 Of the Ranges In Formula
    By DESSTRO in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-20-2017, 08:37 PM
  2. IF function to vlookup in named ranges
    By bevc in forum Excel General
    Replies: 1
    Last Post: 05-31-2016, 04:09 AM
  3. SUM using ADDRESS function and Named Ranges
    By excelroofing in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-24-2015, 08:54 PM
  4. Named ranges using a named formula
    By cad1llac in forum Excel General
    Replies: 6
    Last Post: 10-22-2011, 07:37 AM
  5. Named ranges as values of IF function
    By goels in forum Excel General
    Replies: 4
    Last Post: 10-21-2011, 11:51 AM
  6. Excel 2007 : Named Ranges and Max Function
    By AberdeenGDK in forum Excel General
    Replies: 3
    Last Post: 08-19-2010, 01:27 PM
  7. Excel 2007 : Named ranges no longer function
    By Rick_Stanich in forum Excel General
    Replies: 1
    Last Post: 08-21-2008, 11:11 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1