+ Reply to Thread
Results 1 to 3 of 3

Excel - SUM IF Function (with different conditions)

  1. #1
    Registered User
    Join Date
    09-17-2020
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    18

    Excel - SUM IF Function (with different conditions)

    Hello,

    In the attached Excel sheet there's an overview of different products with different prices.
    Some of them are a one-time cost and the other ones are recurring costs.

    Is it possible to create an IF formula (or a different formula) that automatically checks this for me?
    In column O (total sum) there's the total sum count. Then in column P (One time) I would like the total sum of the one-time cost.
    And in column Q (Recurring) I would like the total sum of all recurring cost.

    On first tab 'Impress' you can find the wanted result in cell P2 en Q3.
    If possible please make a formula that automatically generates this per rule.

    On the second tab 'Complete item list' there's an table which defines what products are 'One time cost' and which ones are recurring.

    Thanks in advance!

    ~

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Excel - SUM IF Function (with different conditions)

    Please try at P2
    =SUMPRODUCT(SUMIFS(E2:M2;D2:L2;'Complete item list'!$B$2:$B$12))

  3. #3
    Registered User
    Join Date
    09-17-2020
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    18

    Re: Excel - SUM IF Function (with different conditions)

    Quote Originally Posted by Bo_Ry View Post
    Please try at P2
    =SUMPRODUCT(SUMIFS(E2:M2;D2:L2;'Complete item list'!$B$2:$B$12))
    Thanks a lot. Exactly what I needed!

+ 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. Use two conditions in textjoin function in excel 2013.
    By magfas in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-15-2018, 04:42 PM
  2. [SOLVED] if multiple conditions are met, perform sum function using index function
    By billrogers184 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2018, 02:49 PM
  3. Replies: 10
    Last Post: 02-20-2018, 10:02 AM
  4. Replies: 2
    Last Post: 01-14-2016, 03:53 PM
  5. [SOLVED] Satisfying 2 conditions using if function or other function
    By aparunkumar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-22-2013, 12:19 PM
  6. Two Conditions Function
    By Freshman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  7. [SOLVED] Count function in excel with different conditions
    By chits in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-21-2005, 04:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1