+ Reply to Thread
Results 1 to 8 of 8

Sum all identical merged columns

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

    Sum all identical merged columns

    Sum all identical merged columns, when Category has repetitions and must be repeated, and the same addition

    It is best to have a one-step formula

    Can someone please help me ? It would be much appreciated. Thanks in advance
    Attached Files Attached Files
    Last edited by choletseng; 12-25-2022 at 01:02 AM.

  2. #2
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: Sum all identical merged columns

    One-step formula, please try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Sum all identical merged columns

    rows rather than columns

    Power Query

    Category Sum
    pencil
    480
    ink
    220
    ruler
    80
    rubber stamp
    60


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by sandy666; 12-25-2022 at 12:52 AM.

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

    Re: Sum all identical merged columns

    That's awesome, thank you both HansDouwe and sandy666

  5. #5
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Sum all identical merged columns

    You are welcome
    Have a nice day

  6. #6
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,466

    Re: Sum all identical merged columns

    Glad to have helped. Thanks for the feedback and rep .

    Happy holidays.

  7. #7
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2508 and WPS V2024(12.1.0.18543)
    Posts
    4,163

    Re: Sum all identical merged columns

    Cell E3 formula

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  8. #8
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2508 and WPS V2024(12.1.0.18543)
    Posts
    4,163

    Re: Sum all identical merged columns

    @choletseng You're Welcome. Glad to help . Thank You for the feedback and rep.

+ 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: 2
    Last Post: 04-03-2022, 08:59 AM
  2. Counting merged cells, or making identical cells appear as if merged
    By Dustin1706 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-02-2022, 11:07 AM
  3. Replies: 4
    Last Post: 04-25-2019, 05:28 AM
  4. Replies: 8
    Last Post: 11-02-2011, 02:45 PM
  5. Why do I get different sums on identical columns.
    By Stardust in forum Excel General
    Replies: 1
    Last Post: 05-05-2006, 01:35 PM
  6. Replies: 0
    Last Post: 05-14-2005, 03:19 PM
  7. TRYING TO SORT, MERGED CELLS HAVE TO BE IDENTICAL?
    By ELIZABETH in forum Excel General
    Replies: 1
    Last Post: 05-03-2005, 12:06 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