Need help ASAP with COUNTIFS/OR, or a better method!

[AU_GradStudent]

Hi all,

I'm turning in my master's thesis today and it's all done EXCEPT one very annoying, aggravating statistic I can't seem to figure out how to get on Excel. I'll tell you what I have, and what I need, and hopefully you can show me the light. It's due at 5 p.m.!

WHAT I HAVE:

I did a content analysis of speeches, and I have several columns that have a "1" or "0" indicating whether or not a particular item is present in that particular speech. They are columns F, H, J, K, L, M, O, Q, S, T, U, V and W. My column "Z" is the independent variable, and I only need to analyze all of the speeches that have a "1" in that column.

Finally, each speech has a "1" or "0" indicating whether its a Republican or Democrat speaking, in column D.

I want to do one analysis for each party for every row that has a "1" in Column Z. What I want to find is which rows have a "1" in Column Z and "1" in at least one of the other several columns I mentioned. I'll do this for values "1" AND "0" in Column D.

Does anyone have any idea how to help me?

[Cheeky Charlie]

Try

=if(and(d2=1,z1=1,sum(f2:w2)),"Republican, independent variable and a hit in f:w","Not all criteria")
=if(and(d2=0,z1=1,sum(f2:w2)),"Democrat, independent variable and a hit in f:w","Not all criteria")