+ Reply to Thread
Results 1 to 2 of 2

count several ranges, and name them:

  1. #1
    Registered User
    Join Date
    10-01-2012
    Location
    Oslo, Norway
    MS-Off Ver
    Excel 2010
    Posts
    26

    count several ranges, and name them:

    Hi.
    I have an excel sheet, where Im counting several events.
    I have succeded in making the counter for the total number, but i like to classify/group the count to make it more detailed.
    Now i have 3 columns which is basis for which event I count, about like this: (ABC is columns and X,Y,Z is the events,)

    (Blue is input and red is output)

    A B C
    X Y Z
    X X Z
    X Z Z
    X Z Z

    TOTAL: XYZ=1
    TOTAL: XXZ=1
    TOTAL: XZZ=1
    What I want to achieve: (to simplify, i named the group criteria date1, date2 etc....)
    A B C D
    date1 X Y Z
    X X Z
    X Z Z
    X Z Z
    date2 X Y X
    X Y X
    X Y Z
    X Y Z


    A B
    date1: TOTAL: XYZ=1
    TOTAL: XXZ=1
    TOTAL: XZZ=1
    date2: TOTAL: XYX=2
    TOTAL: XYZ=2


    (here TOTAL should be in column B, but I cant illustrate that by this textbox apparantly)
    I wish you all a pleasant weekend.

    Regards
    Joachim
    Last edited by Stroem; 10-19-2012 at 09:25 AM.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: count several ranges, and name them:

    Hi Stroem,

    It would be better if you could upload a sample excel workbook.. thanks.


    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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