• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2515
  • Last Modified:

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,"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




0
correlate
Asked:
correlate
  • 3
  • 2
1 Solution
 
Gerwin Jansen, EE MVETopic Advisor Commented:
Can you post a sample sheet?
0
 
correlateAuthor Commented:
Here we go - the full sheet, the formular is in the Sheet "Sums" & the row is highlighted in yellow
EXAMPLE.xlsx
0
 
Rory ArchibaldCommented:
Is it OK to use helper columns on the Data sheet?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
correlateAuthor Commented:
yep absolutely - thank you
0
 
Rory ArchibaldCommented:
Try this. The formula in AU9 on Data is set up to be copied left/right and up/down as required.
EXAMPLE--4-.xlsx
0
 
correlateAuthor Commented:
Works a treat - thank you very very much
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now