Formula or a macro

[robert dydo]

I 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
SHIPPING
RECEIVING
FORKLIFT
SHIPPER
SWEEPER
CHERRY OPS
CAR ASSEMBLY
CAR REPLENISH
MEZ ASSEMBLY
Trained in Job Function Yes or No MEZ REPLENISH
Afternoon Skill Set. # LOADING/RECEIVING FORKLIFT JANITORIAL CHERRY P
CAROUSEL MEZZANINE
ft SHIP REC. Forklift Shipper Sweeper Operations Assembly
Replenish Assembly Replenish
total for job function 11 14 0 11 11 35 6 4 5 28 11 M T W T F S
MOHAMED ABDI 0 0 0 0 0 0 0 0 0 y 1 0 1
FRANK ADAM y 1 y 1 n 0 y 1 y 1 y 1 y 1 y 1 y 1 y 1 y 1 1
KHATIM ADAM 0 y 1 n 0 n 0 n 0 y 1 n 0 n 0 n 0 y 1 n 0
KAIR ALTEJANEY 0 0 0 0 0 0 0 0 0 y 1 0
SHARMA ASOK 0 n 0 n 0 n 0 n 0 y 1 y 1 n 0 n 0 n 0 y 1

 

[michaelacumming]

Hmmm...the text table that you typed in didn't appear too cleanly on
the screen.

You could certainly accomplish this with formulas, but my experience
would lead me in the direction of a Pivot Table in this instance. I
think that you'll see savings in file size, efficiency, and
flexibility.

I'd be more than happy to guide you through this, if that would be
helpful.

Thanks!

Michael Cumming
(e-mail address removed)