+ Reply to Thread
Results 1 to 3 of 3

How to connect units in series

  1. #1
    Forum Contributor
    Join Date
    10-02-2021
    Location
    Thailand
    MS-Off Ver
    365
    Posts
    176

    How to connect units in series

    In the same unit, the numbers are combined to calculate the su
    Example : Cell D11 result 6Set , unit is Set , Total qty = 2+1+3

    Can someone please help me ? It would be much appreciated. Thanks in advance
    Attached Files Attached Files

  2. #2
    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
    80,903

    Re: How to connect units in series

    Please explain the xample:

    AliGW on MS365 Insider (Windows) 32 bit
    A
    B
    1
    QTY
    UNIT
    2
    2
    Set
    3
    1
    Set
    4
    3
    Set
    5
    1
    Piece
    6
    1
    Box
    7
    1
    Box
    8
    1
    Box
    9
    1
    Box
    10
    11
    6Set1Piece4Box
    Sheet: Sheet1

    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.

  3. #3
    Forum Contributor
    Join Date
    10-02-2021
    Location
    Thailand
    MS-Off Ver
    365
    Posts
    176

    Re: How to connect units in series

    I have tried to use this formula, Cell A11 is correct, but the others two are incorrect.
    How can I modify the formula to get the correct ?
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Images Attached Images
    Last edited by choletseng; 10-20-2021 at 08:54 AM.

+ 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. [SOLVED] Sum of units over a time period starting with initial units and a known growth rate
    By MMMMMMMMMJ in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-15-2021, 03:34 AM
  2. Working out overall percentage of units available, units complete against time waitin
    By Darkdeathstalka in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2020, 04:38 AM
  3. [SOLVED] Need to convert hours to billable units and then subtract from the total units provided
    By Slickback724 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 04-14-2020, 04:39 PM
  4. Connect data points from 2 series in line chart
    By henr in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-03-2019, 06:57 PM
  5. Connect points in two different series on scatter graph
    By sa02000 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-11-2009, 06:24 AM
  6. series with different units
    By Lezah in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-18-2007, 07:27 PM
  7. [SOLVED] In excel scatter plot with 2 series, how do I connect xy coordinat
    By Anne-SFRunner in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-04-2005, 04:07 AM

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