Results 1 to 7 of 7

Sumproduct across multiplesheets

Threaded View

  1. #1
    Registered User
    Join Date
    02-10-2013
    Location
    hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    37

    Sumproduct across multiplesheets

    Dear All, Please kindly respond me. I am beating my head since day, and hoping may be I can get help in this forum.
    I would like to do sumprodcut across multiple sheets (Date1 : Date 31). These dates are selected by drop down list (Data validation)
    Sum function which is happening in Sheet “Date2” E16 to I 19, I would like that sum to take place in sheet “summary2” B8 to E11. I want similar function to take place in Summary2 for all the sheets selected by date(dropdown list).


    Note: I will delete that function from sheets (Date1 to Date 31), because I don’t want it to be there. So, this won’t work for me (=Date2!E16) which is simply refering to that cell.

    For more details please find the attached sheet.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1