I have an excel sheet with a column asking gender with values of 1 or 2 and omit non response values. Then what they selected from a separate column with 3 conditions, I need to know the frequency of these conditions put into cells. What formula can I accomplish this with. Thank You for any responses

Your question is way to convoluted to get a response other than... WTF? So here's what I suggest, you first tell us what you are really trying to do because there's probably a better way. Secondly, tell us what the result set should look like. It's much easier to reverse engineer that than decode the gibberish that you wrote.

WTF??? Doesn't matter, what you want is probably on here some where: http://www.cpearson.com/excel/topic.aspx

Ok, yea I understand its pretty vague. I have a list of data from a survey one of the columns asks whether they are male our female and then write in 1 or 2 respectivly. Another column asks what their economic beliefs are 1 liberal, 2 conservative, 3 moderate. I need to find how many male and females chose 1 liberal 2 conservative 3 moderate.

Easy way? Make a copy of the file. Use the sort in excel to sort your data by male/female (1/2) (be sure to include both columns so the answers still match up after the sort) split the data by sex, copy and paste a few columns over Sort each set (male/female) by economic belief count (hint: excel will count rows when you highlight down a column). There are more "proper" ways to do it with the formulas a the site I listed, or you could also create a graph, but I think the above would be the fastest if it's not an insane amount of data.

=COUNT(IF(($B$1:$B$7=1)*($C$1:$C$7=1),$C$1:$C$7)) This assumes your data starts at row 1, ends at row 7, column B is sex, column C is pol views. When you enter the formula, enter Shift-Ctrl-Enter instead of just enter. This will find how many males are liberal. Change the formula to: =COUNT(IF(($B$1:$B$7=2)*($C$1:$C$7=3),$C$1:$C$7)) to see how many females are moderate. Remember to hit S-C-Enter everytime you change the forumla.