please help
 

wonder if someone can help me out?

Please look at this information below:
Each individual has a some kind of a skill set.
Each individual is scheduled certain day (light brown table)
I would like to build a formula which would allow me to find out how many
particular skillsets I have in each day.
This is what would be for one single cell.
=IF(AND(IF(Z15=1,1,0),IF(W15=1,1,0)),1,"")
This is a logical value(TRUE equals 1). for each person I would need a cell
to have this formula and sum it up for all of them.
This task using this method would require if there was 15 people , 15 cells
times 6 days, times 10 skills, just to sum it up to one number.
Imagine 157 people!!!
As you see I need some serious help from you guys.
thank you very much.
Robert

Sounds like you should investigate pivot tables. Look them up in help.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"robert dydo" wrote in message
news:C_PRe.353158$s54.337084@pd7tw2no...
wonder if someone can help me out?

Please look at this information below:
Each individual has a some kind of a skill set.
Each individual is scheduled certain day (light brown table)
I would like to build a formula which would allow me to find out how many
particular skillsets I have in each day.
This is what would be for one single cell.
=IF(AND(IF(Z15=1,1,0),IF(W15=1,1,0)),1,"")
This is a logical value(TRUE equals 1). for each person I would need a
cell
to have this formula and sum it up for all of them.
This task using this method would require if there was 15 people , 15
cells
times 6 days, times 10 skills, just to sum it up to one number.
Imagine 157 people!!!
As you see I need some serious help from you guys.
thank you very much.
Robert

Unfortunately not.
Skill data is under column labels, so is the schedule. Rows labels are
actual names. The result I am looking for is if someone works on Monday,
what kind of skills they bring in. So if I have 100 people on schedule for
Monday I have that much of skills from 11 possibilities of skills.
thanks
EXAMPLE


DAYS OF THE WEEK
NAMES Skills A B C
D E F G H I J K MO TU WE TH
FRI SA
JOHN 1 1
1 1 1
1 1 1 1
TOM
1 1 1 1 1 1
1 1 1 1
BARB 1 1
1 1 1 1 1 1
1 1 1 1 1

Result: Mo Tu We Th Fr Sa
total skills A 1 2 2 2 1 1
total skills B 1 2 2 2 1 1
total skills C 1 2 2 2 1 1
total skills K 2 2 3 3 2 2



"Bob Phillips" wrote in message
...
Sounds like you should investigate pivot tables. Look them up in help.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"robert dydo" wrote in message
news:C_PRe.353158$s54.337084@pd7tw2no...
wonder if someone can help me out?

Please look at this information below:
Each individual has a some kind of a skill set.
Each individual is scheduled certain day (light brown table)
I would like to build a formula which would allow me to find out how many
particular skillsets I have in each day.
This is what would be for one single cell.
=IF(AND(IF(Z15=1,1,0),IF(W15=1,1,0)),1,"")
This is a logical value(TRUE equals 1). for each person I would need a
cell
to have this formula and sum it up for all of them.
This task using this method would require if there was 15 people , 15
cells
times 6 days, times 10 skills, just to sum it up to one number.
Imagine 157 people!!!
As you see I need some serious help from you guys.
thank you very much.
Robert