+ Reply to Thread
Results 1 to 8 of 8

How to addition all cells values of the same persson and make resultat in new table

  1. #1
    Registered User
    Join Date
    07-26-2018
    Location
    NORTH AFRICA
    MS-Off Ver
    2013
    Posts
    47

    Question How to addition all cells values of the same persson and make resultat in new table

    Hi all members
    before i write this thread i looked in the forum about same subject of mine but i couldnt find any resultat .
    In attached file example of my workbook, as i write in the title(how to addition all cells values of the same persson and make resultat in new table) i hope to find the right formula
    https://www.mrexcel.com/board/thread...table.1202539/
    Attached Files Attached Files
    Last edited by SBAY3I; 04-17-2022 at 10:26 PM.

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: How to addition all cells values of the same persson and make resultat in new table

    Please try this in cell N3 and copy down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.



    N
    O
    P
    2
    TOTAL
    NAME & PRENAME
    3
    277
    NAME 1
    1
    4
    178.5
    NAME 2
    2
    5
    28
    NAME 26
    3
    6
    34
    NAME 36
    4
    Dave

  3. #3
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: How to addition all cells values of the same persson and make resultat in new table

    The TRANSPOSE function may require that you array enter that formula in Excel version 2016 (your profile).

    If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

  4. #4
    Registered User
    Join Date
    07-26-2018
    Location
    NORTH AFRICA
    MS-Off Ver
    2013
    Posts
    47

    Re: How to addition all cells values of the same persson and make resultat in new table

    Quote Originally Posted by FlameRetired View Post
    The TRANSPOSE function may require that you array enter that formula in Excel version 2016 (your profile).

    If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
    hi
    thanks for your reply, my excel version is 2013, i update my profile
    i paste the formula in the cell N3 but not accepted

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: How to addition all cells values of the same persson and make resultat in new table

    I tend to over complicate things. This would be far simpler.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    07-26-2018
    Location
    NORTH AFRICA
    MS-Off Ver
    2013
    Posts
    47

    Re: How to addition all cells values of the same persson and make resultat in new table

    Quote Originally Posted by FlameRetired View Post
    I tend to over complicate things. This would be far simpler.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    #NOM?
    that what i get

  7. #7
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,396

    Re: How to addition all cells values of the same persson and make resultat in new table

    It's working at my end. Please see the attached with that last formula.

  8. #8
    Registered User
    Join Date
    07-26-2018
    Location
    NORTH AFRICA
    MS-Off Ver
    2013
    Posts
    47

    Re: How to addition all cells values of the same persson and make resultat in new table

    Quote Originally Posted by FlameRetired View Post
    It's working at my end. Please see the attached with that last formula.
    glad to help, its working

+ 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] How can I make a formula from a table of values?
    By lOYvEpi6M87nEoIF0ul8 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-19-2018, 02:39 PM
  2. Make certain cells uneditable based on values in other cells
    By ramatthews in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-03-2016, 11:53 AM
  3. Replies: 6
    Last Post: 01-10-2016, 12:49 PM
  4. extract number values from a table and make a list
    By mischge in forum Excel General
    Replies: 27
    Last Post: 08-14-2013, 04:00 AM
  5. Replies: 1
    Last Post: 01-14-2013, 04:01 AM
  6. Replies: 11
    Last Post: 08-12-2012, 03:13 PM
  7. Code to make select values and put in a table
    By Pipopper in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-14-2009, 12:37 PM

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