+ Reply to Thread
Results 1 to 8 of 8

Adding data from variable cells

  1. #1
    Registered User
    Join Date
    11-28-2014
    Location
    Birmingham, England
    MS-Off Ver
    Windows 7
    Posts
    25

    Adding data from variable cells

    Hi Experts,

    I'm after a bit of help.

    I have a spreadsheet that details Pass/Fail rates. I would usually just use a VLookup to calculate but the way the spreadsheet is created it has merged data.

    From the attached example rows 5 & 6 the total has been merged in Column F. however in Columns K - N the values are in individual rows (from a different spreadsheet based on Column Data B & D)

    I need a formula that will look up the individual data from Row F and calculate it as a total in Columns K - N rather than provide it as individual row data in Columns K - N. In the example Row 6 Column O- R will be empty.

    The only data that is unique will be in Column D, however merged data will use the same number found in Column B.

    Not sure if I have explained that very well
    Attached Files Attached Files

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

    Re: Adding data from variable cells

    Please try at O3:Q8

    =IF($F3="","",K3+K4*($F4=""))
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-28-2014
    Location
    Birmingham, England
    MS-Off Ver
    Windows 7
    Posts
    25

    Re: Adding data from variable cells

    Many thanks Bo_Ry works perfectly

  4. #4
    Registered User
    Join Date
    11-28-2014
    Location
    Birmingham, England
    MS-Off Ver
    Windows 7
    Posts
    25

    Re: Adding data from variable cells

    Hi Just looking for a quick update on the formula provided, if in Column F more than two rows have been merged what would the formula be? Is it possible to change it to take into account that it could be variable Rows that have been merged using the original provided solution?

    =IF($F3="","",K3+K4*($F4=""))

    Many thanks

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

    Re: Adding data from variable cells

    Please provide sample with expected answer.

  6. #6
    Registered User
    Join Date
    11-28-2014
    Location
    Birmingham, England
    MS-Off Ver
    Windows 7
    Posts
    25

    Re: Adding data from variable cells

    Thanks Bo_Ry see example attached (Rows 9, 10 & 11) with the expected answer.
    Attached Files Attached Files

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

    Re: Adding data from variable cells

    Assume that blank row has same P/N and date

    O2:Q11
    =IF($F3="","",SUMIFS(K3:K11,$B3:$B11,$B3,$E3:$E11,$E3))

  8. #8
    Registered User
    Join Date
    11-28-2014
    Location
    Birmingham, England
    MS-Off Ver
    Windows 7
    Posts
    25

    Re: Adding data from variable cells

    Solved it again! Many thanks Bo_Ry

+ 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. Replies: 13
    Last Post: 07-16-2016, 10:53 PM
  2. Macro to create chart using XLtoRight Variable for adding column data
    By Hondahawkrider in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-07-2016, 11:54 PM
  3. [SOLVED] Adding specific text to cells based on another cells data criteria
    By JohnnyBoyxxx in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-26-2015, 02:08 PM
  4. Replies: 2
    Last Post: 08-22-2014, 03:55 AM
  5. Replies: 4
    Last Post: 07-12-2013, 12:14 PM
  6. adding variable sums from different cells
    By ioneabee in forum Excel General
    Replies: 5
    Last Post: 05-13-2010, 04:09 AM
  7. Adding "fixed" data to variable length data
    By [email protected] in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-16-2006, 05:10 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