+ 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
    50

    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
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,347

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

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

    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
    Office 365 v 2403
    Posts
    13,396

    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