+ Reply to Thread
Results 1 to 4 of 4

Combining two formulas

  1. #1
    Registered User
    Join Date
    05-15-2017
    Location
    Groningen
    MS-Off Ver
    Office Excel 2013
    Posts
    4

    Combining two formulas

    Hi all,

    This is my first post so hopefully I get it right in one try. I have the following question:
    How do I combine two Sumifs in one formula?

    What I need is that Excel first calculates the total hours based on two criteria (Function A and Service A) which is 4 hours in my example
    Then Excel should calculate the total hours based on two other criteria (Function B and Service B) which is 1 hour in my example
    Then Excel should add these two up, so 4+1 so the cell shows the final result being 5.
    (The hours are shown in a different tab)

    I know that by using multiple cells it's very easy, however I would like to process this formula in one cell.

    Example
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Combining two formulas

    something like that?
    =SUM(SUMIFS(Table2[Uren (t)],Table2[Function],"Function A",Table2[Service],"Service A"),SUMIFS(Table2[Uren (t)],Table2[Function],"Function B",Table2[Service],"Service B"))

  3. #3
    Registered User
    Join Date
    05-15-2017
    Location
    Groningen
    MS-Off Ver
    Office Excel 2013
    Posts
    4

    Re: Combining two formulas

    Ok, I don't know why I didn't think of this. I spent half an hour on working AND, OR and IF in the formula. My brain had a malfunction I guess... thanks a lot for your answer!

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Combining two formulas

    You are welcome

    Read my dancing footnote , thanks
    Last edited by sandy666; 05-16-2017 at 05:52 AM.

+ 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] Combining if formulas
    By 3345james in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 10-19-2016, 12:13 PM
  2. need some help combining some formulas
    By daviddc114 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-31-2013, 04:34 PM
  3. Help Combining Formulas
    By artiststevens in forum Excel General
    Replies: 2
    Last Post: 02-24-2012, 03:15 AM
  4. Combining two formulas
    By mrggutz in forum Excel General
    Replies: 13
    Last Post: 09-24-2010, 12:47 PM
  5. Combining IF formulas
    By donyc in forum Excel General
    Replies: 4
    Last Post: 09-09-2010, 05:42 PM
  6. combining 2 formulas
    By cat1410 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 08-02-2008, 09:34 PM
  7. Combining two formulas
    By Khalil Handal in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-07-2005, 05:07 AM

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