3 Array Formula

S

Shazam

I have an EEO spreadsheet that I need to put an array formula for Sex, Race,
& EEO category. I have Sex in the "C" column, Race in the "D" column, and
EEO in the "G" column, and "H7" for the Male gender match, "I7" for "01" Race
code match, and EEO category 01 is in "J7". I can get my array to work if I
delete the last EEO segment in the formula out, but I cannot get it to work
with it. Do I have too many segments for it to work? Below is my formula:
Please help. Thank you.

=SUM(IF($C$4:$C$443=$H$7,IF($D$4:$D$443=$I$7,IF($G$4:$G$443=$J$7,1,0),0)))
 
S

Shazam

I am reviewing the websites you provided, which I really appreciate. The
formula works great! Thank you so very much!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top