+ Reply to Thread
Results 1 to 3 of 3

Sum values of multiple cells IF data exists in neighboring cells

  1. #1
    Registered User
    Join Date
    05-16-2009
    Location
    New Orleans, LA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Sum values of multiple cells IF data exists in neighboring cells

    Can anyone help me to figure out a cell formula that would accomplish this:

    I want cell "G1" to show the sum of the numbers in A1, C1, and E1 IF data exists in B1, D1, and/or F1

    So if data only exists in B1 and D1, but F1 is blank, then "this cell" will only show the sum of A1 and C1 (and will not include the number data from E1 in the sum).

    This is for a job payment tracking spreadsheet. I will have six sets of two columns:

    A1: Payment 1
    B1: Payment 1 Paid on (Date)
    C1: Payment 2
    D1: Payment 2 Paid on (Date)
    E1: Payment 3
    F1: Payment 3 Paid on (Date)

    ... and the G1 would be:

    G1: Total Amount Paid So Far

    When Payment 1 is received from the client, I will enter that day's date in B1... etc.


    If anyone has any other methods to do this, I am more than open to suggestions.

    Thanks!
    Last edited by hockey2112; 04-13-2010 at 08:46 PM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Sum values of multiple cells IF data exists in neighboring cells

    In G1, formatted as General:

    =(A1*ISNUMBER(B1)) + (C1*ISNUMBER(D1)) + (E1*ISNUMBER(F1))
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    05-16-2009
    Location
    New Orleans, LA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Sum values of multiple cells IF data exists in neighboring cells

    Perfect! Thank you so much!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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