No array is necessary, these are simple COUNTIF formlas:

To get As total:
=COUNTIF(B:B,"x")+COUNTIF(F:F,"x")

To get Eu total:
=COUNTIF(C:C,"x")+COUNTIF(G:G,"x")

To get Am total:
=COUNTIF(D:D,"x")+COUNTIF(H:H,"x")
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Guntars" wrote:

In my opinion this is quit advanced stuff I am trying to do here. Thats 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, thats 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