count several ranges, and name them:

[Stroem]

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=1What 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

[dilipandey]

Hi Stroem,

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


Regards,
DILIPandey

<click on below 'star' if this helps>