+ Reply to Thread
Results 1 to 5 of 5

Sum up to separate columns and show it in a single cell separately

  1. #1
    Registered User
    Join Date
    01-25-2020
    Location
    Bangladesh
    MS-Off Ver
    2007
    Posts
    33

    Sum up to separate columns and show it in a single cell separately

    Hi,

    Please download the sample workbook first.

    I want the formula for "B13" and "B14" on the basis of first table.
    In B13 and B14 "/" means a sign or symbol not means diveded by.

    My english is poor thats why it is difficult for me to explain, I hope you understand.


    Thganks in advane.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Sum up to separate columns and show it in a single cell separately

    copy paste below in C13 and drag down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,763

    Re: Sum up to separate columns and show it in a single cell separately

    You can put this formula in B13:

    =SUMIF($A$3:$A$8,$A13,$B$3:$B$8)&"/"&SUMIF($A$3:$A$8,$A13,$C$3:$C$8)

    then copy it into B14.

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    01-25-2020
    Location
    Bangladesh
    MS-Off Ver
    2007
    Posts
    33

    Re: Sum up to separate columns and show it in a single cell separately

    Your formula was correct.

    But sorry its my mistake that I provided you with incomplete data. Please find the new updated data.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-25-2020
    Location
    Bangladesh
    MS-Off Ver
    2007
    Posts
    33

    Re: Sum up to separate columns and show it in a single cell separately

    Thanks I solved my problem.
    Appreciate you help.
    Thanks for you time and effort.

+ 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: 5
    Last Post: 01-29-2020, 09:51 PM
  2. [SOLVED] Counting letters and numbers separately in a single cell
    By ss2012 in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 08-27-2019, 06:22 PM
  3. [SOLVED] arrange text and numbers separately in a single cell
    By nadimqaisar in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-25-2015, 06:43 PM
  4. [SOLVED] HELP - Based on "C" cell entry, Find mismatch figure in row. And save/show separately
    By ExcelUser2707 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-07-2014, 04:23 AM
  5. Replies: 6
    Last Post: 11-29-2013, 10:52 PM
  6. [SOLVED] Copy content of several columns into a single cell and change format on separate lines
    By Biffilicious in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2012, 05:05 AM
  7. Replies: 1
    Last Post: 04-23-2008, 07:33 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