I think your description of where your column headers are located is
misleading.

Let's assume your column headers are in the range B1:I1. Names in the range
A2:A11.

This array formula** will return the count of *unique* names that have a "X"
in any column corresponding to Europe.

=SUM(--(FREQUENCY(IF((B2:I11="x")*(B1:I1="Europe"),ROW(B2 :I11)),ROW(B2:I11))0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

For example:

...........A..........B..........C..........D
1................Europe....Asia...Europe
2...Name1.....X.......................X
3...Name2..................X..........X

The above formula will return 2.


--
Biff
Microsoft Excel MVP


"Guntars" wrote in message
...
In my opinion this is quit advanced stuff I am trying to do here. That's
why
I am posting here were all the excel experts meet.
This is my challenge: in Col. A2:A11 I have names of workers. On top of
the
table in row B2:I2 I have vacation names where employees been traveling B2
(Asia), B3 (Europe), B4 (America), B5 (Australia), B6 (Asia), B7 (Europe),
B8
(America), B9 (Australia). As you can see continent names are duplicated
in
B2:I2 range of cells, that's because it was I different trip.
What I want is to sum in one cell, how many employees have been to Europe.
From what I understand this is calling for array formula.
Thank you very much.
Here is replicate of excel table:
As Eu Am Au As Eu Am
Name 1 x X X
Name 2 X
Name 3 X X
Name 4 X X
Name 5
Name 6 X X X
Name 7 X
Name 8 X X X
Name 9 X
Name 10 X