Results 1 to 10 of 10

Total a cell starting from first sheet upto the sheet name selected from drop-down list

Threaded View

  1. 09-20-2015, 11:21 AM #9
    AlKey
    AlKey is offline
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Total a cell starting from first sheet upto the sheet name selected from drop-down lis

    Quote Originally Posted by kmahesh View Post
    Alkey your Sumproduct formula is not working , what i get is #Ref!
    Please see attached file with formulas
    Attached Files Attached Files
    Last edited by AlKey; 09-20-2015 at 11:31 AM.
    Reply With QuoteRegister To Reply
« 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. Drop down list that changes selected sheet
    By Mike_StGeorge in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 06-22-2017, 01:39 PM
  2. [SOLVED] Populate Cell of A sheet using the value of a drop list of another sheet
    By Ledis in forum Excel General
    Replies: 5
    Last Post: 09-22-2014, 05:28 AM
  3. Hide all worksheet except 5 input sheets and a 6th sheet selected in a drop down list
    By brianfarrell06 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-15-2014, 10:21 AM
  4. HELP : Unhide sheet only the Selected option from drop down list
    By shiven.k in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-11-2013, 12:37 AM
  5. select a sheet from a drop down menu and move the row in the selected sheet
    By AlienPump in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2012, 02:21 PM
  6. Extract data from sheet selected from drop down list
    By kanight in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2011, 07:20 AM
  7. Value selected on drop down list, look-up on different sheet
    By liseladele in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-21-2006, 10:30 PM

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