Posted on 2011-05-09
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,"GeneralMgtNED",Data!T:AH,"SERVICES").
I have also tried =COUNTIFS(Data!D:R,"=GeneralMgtNED",Data!T:AH,"=SERVICES").
Both give me an answer of 5, it should be something like 28.
Can anybody help