Home

Countif and and or match or function

eileen chan
Occasional Visitor

Hi I'm trying to take all of our employee's diversity information (similar to the example A) and transfer the data to example B). We have around 6,000-7,000 employees and I've tried several countif formulas, but my numbers don't match what is on example A when I audit. Please let me know if you have additional questions.

Groups Worker Gender Race
Events Ashley Adams Female White
Marketing James Jungle Male Hispanic or Latino
HR Laura Log Female White
Client Jeff Jingle Male Asian
Events Alyssa Apple Female Hispanic or Latino
Fashion Flore Flam Female Decline

 

Example B

Row Labels Female Male Not declared (blank) Grand Total Female Male Amer Indian Asian Black Hispanic HI or Pac Island 2 or More White Decline Blank Total
Clients   5     5 0% 100% 0% 40% 0% 0% 0% 0% 0% 60% 0% 100%
American Indian or Alaska Native                                  
Asian   2     2                        
Black or African American                                  
Decline to Provide    3     3                        
Hispanic or Latino                                   
Two or More Races                                  
White                                  
(blank)                                  
Related Conversations