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                                  
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies