Tom Crowfoot
asked on
COUNTIFS
Dear Experts,
I have large Excel 2010 spreadsheet where I can to do some analysis on rows. I am trying to do a COUNTIFS formular, but I keep getting the wrong answer.
Bascially the spreadsheet (Sheet name is Data) is a list of people, there is then then in columns D to R there are text values depicting somesone job responsibilities. Then in columns T to AH there are text values depicting the industry(s)
What I am trying to do is create a matrix of job responsibilities across industries.
So for example if I was looking for people with the following codes:
Job Responsibilites = "GeneralMgtNED" and an industry of "SERVICES"
the formular I am trying is =COUNTIFS(Data!D:R,"Genera lMgtNED",D ata!T:AH," SERVICES") .
I have also tried =COUNTIFS(Data!D:R,"=Gener alMgtNED", Data!T:AH, "=SERVICES ").
Both give me an answer of 5, it should be something like 28.
Can anybody help
I have large Excel 2010 spreadsheet where I can to do some analysis on rows. I am trying to do a COUNTIFS formular, but I keep getting the wrong answer.
Bascially the spreadsheet (Sheet name is Data) is a list of people, there is then then in columns D to R there are text values depicting somesone job responsibilities. Then in columns T to AH there are text values depicting the industry(s)
What I am trying to do is create a matrix of job responsibilities across industries.
So for example if I was looking for people with the following codes:
Job Responsibilites = "GeneralMgtNED" and an industry of "SERVICES"
the formular I am trying is =COUNTIFS(Data!D:R,"Genera
I have also tried =COUNTIFS(Data!D:R,"=Gener
Both give me an answer of 5, it should be something like 28.
Can anybody help
Can you post a sample sheet?
ASKER
Here we go - the full sheet, the formular is in the Sheet "Sums" & the row is highlighted in yellow
EXAMPLE.xlsx
EXAMPLE.xlsx
Is it OK to use helper columns on the Data sheet?
ASKER
yep absolutely - thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Works a treat - thank you very very much