Sumproduct help

[houstonoldham]

Hello Everyone,

This is my first post on an Excel threat so hang with me please!

I am having an issue with SUMPRODUCT for two specific sheets in my workbook. I have used SUMPRODUCT multiple times throughout this workbook, but this specific sheet will not let me reference a data tab that I have downloaded from my company's database. I have reformatted the data to have the only three columns I need but even with the reformatting, the sheet isnt recognized by my formulas. Attached to this message is the file I am working with minus all the other tabs that have company information on them. I have put instructions on the excel sheet for anyone that is willing to help me!

Thank yall so much!

Houston

[jubiesxl]

Change the formulas as under

=SUMPRODUCT(--(DATA!$A:$A="Asian"),--(DATA!B:B="Managers & Supervisors"))

Also there are 4 #NA in the two or more races causing the issue with formula, change it to Unknown

Also you can try using pivot table with grouping for easier tables

[jeffreybrown]

Maybe this will be better and you should probably stray away from referencing entire columns...

=COUNTIFS(DATA!$A$2:$A$2070,$B11,DATA!$B$2:$B$2070,C$10) >> 13

Drag down and to the right

[houstonoldham]

Alright thanks for yalls help! For some reason the way the data file comes across on my computer does not let me reference it at all from any tab. I created a pivot table and just had to do some reformatting in my workbook to make it all presentable.

Thanks again!