+ Reply to Thread
Results 1 to 5 of 5

Formula Using Sumif or Sumproduct and If statement

  1. #1
    Registered User
    Join Date
    04-23-2009
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    40

    Formula Using Sumif or Sumproduct and If statement

    Hello All,

    I need a formula that will look at 3 columns of data and return a sum based on the following understanding:

    If C1 is blank, look at A1 + B1 and return a sum; otherwise, return the value in column C1. I need it to do this down the entire column and return the total sum. Essentially, columns A1 and B1 are budget numbers and C1 will be the actual number once I have identified it. C1 will trump A1 + B1 at that point.

    Column A Column B Column C Answer
    125 362 = 487
    50 623 = 623
    450 =450
    500 750 =750

    sum total = 2,310

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    18,137

    Re: Formula Using Sumif or Sumproduct and If statement

    How about

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Then use SUM in the bottom row for the total.

    Or are you saying that you don't want to actually show the "Answer" column?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider (Windows 10)
    Posts
    49,623

    Re: Formula Using Sumif or Sumproduct and If statement

    @Chavez000 - your user profile is probably out-of-date - please update it with your current version of Excel. Thanks!
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  4. #4
    Registered User
    Join Date
    04-23-2009
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: Formula Using Sumif or Sumproduct and If statement

    Hi Jazzer,

    the formula you propose would require another column. I dont want a column with each row calculation shown. I want a formula that looks down all 3 columns, performs the calculation and returns the sum in one cell.

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    12,031

    Re: Formula Using Sumif or Sumproduct and If statement

    Please try
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If it's an issue this will calculate faster.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by FlameRetired; 03-16-2020 at 08:25 PM.
    Dave

+ 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. SUMPRODUCT or SUMIF Formula Help Please
    By reddaze in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-01-2017, 08:27 AM
  2. Sumproduct formula with sumif?
    By aqalna in forum Excel General
    Replies: 1
    Last Post: 10-05-2016, 06:49 PM
  3. [SOLVED] IF statement clause and SUMIF statement formula help!!!!
    By djmatok in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 10-28-2015, 04:48 PM
  4. adding average to a sumproduct/sumif statement
    By cartica in forum Excel General
    Replies: 4
    Last Post: 11-26-2013, 03:12 PM
  5. How can I convert this sumif statement into a Sumproduct?
    By ggremel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-26-2010, 05:47 PM
  6. Sumproduct or sumif formula
    By vasto in forum Excel General
    Replies: 6
    Last Post: 08-24-2009, 03:06 PM
  7. SumIf/SumProduct Formula Help
    By Jacinthe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-10-2005, 07:06 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