[Solved] Using data from 2 columns in formula

[cpetersen]

Hello. I have an "ethnicity" column and a "Duplicate" column. Input for "Ethnicity" column will be numbers 1 through 8. I am able to use the COUNTIF function to total the quantity of each number. The "Duplicate" column will be a "Y" or "N". I need to write a formula that will count the number of "N" AND total the quantity of each "Ethnicity" number that have "N" in the "Duplicate" column. I have attached a copy of the sheet. I appreciate any help I can get with this project. We need this data for grant applications.

 

[Ridwan]

Hello. I have an "ethnicity" column and a "Duplicate" column. Input for "Ethnicity" column will be numbers 1 through 8. I am able to use the COUNTIF function to total the quantity of each number. The "Duplicate" column will be a "Y" or "N". I need to write a formula that will count the number of "N" AND total the quantity of each "Ethnicity" number that have "N" in the "Duplicate" column. I have attached a copy of the sheet. I appreciate any help I can get with this project. We need this data for grant applications.

Hi cpetersen,
Thanks for sharing your problem with us.
I have inserted a new row for inserting the relevant code for ethnicity (e.g. A34:H34)

Then, I inserted the following formula in cell A39 and dragged the Fill Handle till cell H39:

=COUNTIFS($M$3:$M$27, "N", $L$3:$L$27, A34)

Thus, I have got the count of each ethnicity for having "N" in the duplicate column.

I am attaching the workbook for your convenience. Please reply if you have any further confusion. Stay with ExcelDemy.

Best Regards,
ExcelDemy Team

 

[cpetersen]

This is perfect! I can now calculate the data for the grants. Thank you so much for your input!