Amanda92385
New Member
Hi - I've searched far and wide and can't find something online that fits (or I just didn't understand what I was reading...)
I have a spreadsheet set up with manager names horizontal across the top, let's say columns C-M, column A contains job codes (Job1, Job2, Job3, Job4) and column B has one of 3 names (regional, regional peer, national) then all the area in between, C2 - M3000 have a variety of head counts.
I don't want a sum. I want to count the number of jobs under John Smith that have headcounts for a regional job, regional peer job and national job
Here's what the spreadsheet would look like
JobCode
Cut John Smith Sally Sue Bob Brady Mark Jones
Job1
Regional 5 1 4 0
Job2
National 0 3 3 0
Job3
National 0 0 1 0
Job4
Regional Plus 1 0 0 10
Job5
Regional 3 0 0 1
So my results would look like this:
Manager Regional Regional Plus National
John Smith 2 1 0
Sally Sue 1 0 1
Bob Brady 1 0 2
Mark Jones 1 1 0
Any help would be so appreciated. I can't figure out what I'm supposed to do to get this to work. I read about lookups, mmult etc. but really just couldn't get it to work for me, I tried a slew of different things so any suggestions based on the example above would be so appreciated.
Thank you!!!!
Amanda
I have a spreadsheet set up with manager names horizontal across the top, let's say columns C-M, column A contains job codes (Job1, Job2, Job3, Job4) and column B has one of 3 names (regional, regional peer, national) then all the area in between, C2 - M3000 have a variety of head counts.
I don't want a sum. I want to count the number of jobs under John Smith that have headcounts for a regional job, regional peer job and national job
Here's what the spreadsheet would look like
JobCode
Cut John Smith Sally Sue Bob Brady Mark Jones
Job1
Regional 5 1 4 0
Job2
National 0 3 3 0
Job3
National 0 0 1 0
Job4
Regional Plus 1 0 0 10
Job5
Regional 3 0 0 1
So my results would look like this:
Manager Regional Regional Plus National
John Smith 2 1 0
Sally Sue 1 0 1
Bob Brady 1 0 2
Mark Jones 1 1 0
Any help would be so appreciated. I can't figure out what I'm supposed to do to get this to work. I read about lookups, mmult etc. but really just couldn't get it to work for me, I tried a slew of different things so any suggestions based on the example above would be so appreciated.
Thank you!!!!
Amanda