Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Challenging SUMING situation!
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
suming every 3rd column | Excel Worksheet Functions | |||
testing while suming | New Users to Excel | |||
suming in add-ins | Excel Worksheet Functions | |||
Suming up a Lookup | Excel Worksheet Functions | |||
Suming 2 cells if 1 = #N/A | Excel Worksheet Functions |