+ Reply to Thread
Results 1 to 9 of 9

Sum the count of ...

  1. #1
    Registered User
    Join Date
    04-01-2017
    Location
    Belgium
    MS-Off Ver
    2020
    Posts
    21

    Sum the count of ...

    Hi all,

    I just have a question on what is possible (most likely the answer is yes)

    To give you a clear Idea of what I'm trying to make, I'll explain what it is about.
    I receive packages from external businesses in 3 different locations. Every location keeps data about the packages coming in in the exact same data template. Data like : what brand, the date and hour, what way its paid,....

    What I would like to create a pivot about is the different brand types. In all cities some brands are the same, so to get them in 1 pivot, they would need to sum up based on the brand name.

    IS there a way to sum the count of "Brand" from different workbooks?

    Regards,

    Robbe

  2. #2
    Registered User
    Join Date
    04-01-2017
    Location
    Belgium
    MS-Off Ver
    2020
    Posts
    21

    Re: Sum the count of ...

    To give an example of what I mean,
    Please see screenshot
    2017-05-22_20-09-07.jpg

    how do I create a table that adds those up ?

  3. #3
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Sum the count of ...

    Use the Power Query to connect data

  4. #4
    Registered User
    Join Date
    04-01-2017
    Location
    Belgium
    MS-Off Ver
    2020
    Posts
    21

    Re: Sum the count of ...

    Cool thanks!
    Now I got this far:
    2017-05-22_21-50-58.jpg

    How will I be able to know from which data source the data is (from which city) ? Can I add a custom column that says the data source?
    any other possibility?

  5. #5
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Sum the count of ...

    You have to - otherwise all the data will aggregate and you will not recognize what they are about

  6. #6
    Registered User
    Join Date
    04-01-2017
    Location
    Belgium
    MS-Off Ver
    2020
    Posts
    21

    Re: Sum the count of ...

    Great! but how do I add that custom column? whats the formula to that info ?

  7. #7
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Sum the count of ...

    For example:
    1 insert a custom column
    2. formula = "COLORADO"
    3. ok
    Remember the same column header names

  8. #8
    Registered User
    Join Date
    04-01-2017
    Location
    Belgium
    MS-Off Ver
    2020
    Posts
    21

    Re: Sum the count of ...

    Yes, but this wont automatize it if more data is entered.
    Dont want to manually add that everytime

  9. #9
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: Sum the count of ...

    I do not see the data layout, so I do not know how I can help you

+ 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: 1
    Last Post: 05-19-2017, 07:37 AM
  2. Replies: 17
    Last Post: 04-11-2016, 11:14 PM
  3. Macro count items in sheet2 and provide count in embedded label in sheet1
    By jaredmccullough in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-05-2015, 11:27 AM
  4. [SOLVED] for every line I browse make a count and post this count in a cell (fiouuu)
    By historic777 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2013, 06:41 AM
  5. [SOLVED] Filtering macro, count number of rows and include count in last column.
    By Folshot in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2012, 07:17 AM
  6. Range.columns.count property returns wrong count after union operation
    By gopinan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2008, 04:48 AM
  7. Replies: 18
    Last Post: 09-06-2005, 06:05 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