+ Reply to Thread
Results 1 to 3 of 3

Sum data if it exists in another cell (override data from typical cell)

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Sum data if it exists in another cell (override data from typical cell)

    Hi guys

    I need help with writing a formu,la whereby i need a sum function to take data from a different cell IF A VALUE exists.... because this needs to override other value data.

    See my spreadsheet and it might make more sense. this is because i am calculating accrual info separately for employee pay.

    Thank you
    Attached Files Attached Files
    Thanks,

    R.



  2. #2
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2019 H: 365
    Posts
    940

    Re: Sum data if it exists in another cell (override data from typical cell)

    Hi rayted,

    Can the Yes/No's in column E drive the criteria? If so you could use 2 SUMIFS as follows:

    =SUMIF(E3:E16,"Yes",B3:B16)+SUMIF(E3:E16,"No",I3:I16)

    Alternatively you could use: (which is driven based on whether any data is contained in column I)

    =SUMIF(I3:I16,"",B3:B16)+SUMIF(I3:I16,"<>"&"")

    Regards,

    Snook
    Last edited by The_Snook; 06-15-2020 at 11:45 AM.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Sum data if it exists in another cell (override data from typical cell)

    Another option
    =SUM(IF(I3:I16="",B3:B16,I3:I16))

    Probably needs Ctrl Shift Enter, rather than just Enter.

+ 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. Copy value of one cell and past in new column only where data exists
    By MikeWaring in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-24-2017, 11:00 AM
  2. Cannot get Data Validation to override a macro driven cell.
    By bralew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-19-2016, 10:28 AM
  3. [SOLVED] Data Entry - Userform, override and update data instead of duplicate data.
    By mwinter in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-07-2014, 10:25 AM
  4. [SOLVED] Checking if Cell Data exists in an array
    By Axey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2013, 09:38 AM
  5. Replies: 2
    Last Post: 12-09-2011, 02:49 PM
  6. Deleting cell data in worksheet A if it exists in worksheets B, how?
    By Bern78 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-08-2011, 06:22 AM
  7. Override the data in the cell when checkbox is clicked
    By gsweta in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2009, 10:57 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