+ Reply to Thread
Results 1 to 3 of 3

Can I nest a sumifs formula to to set multiple sum ranges within a single formula

  1. #1
    Registered User
    Join Date
    05-21-2014
    Posts
    4

    Can I nest a sumifs formula to to set multiple sum ranges within a single formula

    Hello All

    I was wondering if its possible to create a sumifs formula that contains several sum ranges, as well as the multiple criteria

    I have attached a sample document, and i was to type the sort of formula i was trying to get it would be like this

    =SUMIFS(Sheet1!E:E,Sheet1!$B:$B,Sheet3!$E4,Sheet1!$D:$D,Sheet3!$H4),sumifs(Sheet1!I:I,Sheet1!H:H,Sheet3!F4,Sheet1!D:D,Sheet3!H4) - excel doesnt like this formula

    And to explain

    There is a list of names, and the hours they attend at work (Sheet1). What i want to do is , when i enter the name and the date on my summary sheet (Sheet 3), is for excel to extract the data based on the 2 criteria - the date and the name. So if i put a name and a date, it will for example, put the worked hours for that name and date - and then if i put a different date,it will extract the data for that date.

    Is this possible?

    Many Thanks for your time
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,593

    Re: Can I nest a sumifs formula to to set multiple sum ranges within a single formula

    So, you do already have a lot of data in the format shown in sheet1? And you want to convert it to the form shown on sheet3? In that case, how much data?
    I'm leaning more towards a macro solution for this.

  3. #3
    Registered User
    Join Date
    05-21-2014
    Posts
    4

    Re: Can I nest a sumifs formula to to set multiple sum ranges within a single formula

    Hi there, thanks for replying

    Sheet 1 would contain data for around 20 people, which is keyed daily, and then each morning i will update sheet 3 with that info - Sheet 3 will also contain formulas to draw in information from other sources based on the info keyed
    The idea being, that sheet3 will be used to provide historical data for the year, and the ability to pivot to show whichever data is being analysed

    Its probably not much effort to key it manually, but if there is a quicker way using formulas.....

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Vlookup & multiple sumifs formula question
    By lilsnoop in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-27-2014, 07:42 PM
  2. SUMIFS with multiple SUM and Criteria Ranges
    By Xerxies in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-20-2013, 09:01 AM
  3. Combined vlookup and sumifs in a single formula
    By mrexcelrc1 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-27-2012, 04:54 PM
  4. Multiple If in SumIfs formula
    By notimepelican in forum Excel General
    Replies: 10
    Last Post: 01-24-2012, 04:51 AM
  5. Can you nest multiple SUMIFS into a formula?
    By DorothyFan1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-29-2011, 05:17 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1