For multi-criteria counts,
you could use sumproduct, something like this
In say, E2: =SUMPRODUCT((A2:A10="female")*(B2:B10=5))

Then there's also the Pivot table Option,
which is fast & easy to set up to give you all the analysis stuff at one go

Assume your col headers in A1:B1 are : Gender, Val1
Select any cell in the table, click Data Pivot table
Click Next Next
In step 3, click Layout, then:
drag n drop Gender into the ROW area
drag n drop Val1 into the COLUMN area
drag n drop Val1 into the DATA area
(double click on it, change it to summarize by: COUNT)
Click OK Finish. That's it.

Hop over to the pivot sheet (just to the left) for the quick analysis results:
The full listing of all unique Genders will appear in the ROW area,
cross-tabbed with all the unique Val1 values in the COLUMN area, and the
corresponding counts of each Gender-Val1 combination in the DATA area. Yep,
the full show at one go.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---
"Sandizet" wrote:
I am trying to countif - with two columns of information. if the values in
column A = certain criteria, i want to count the number of times a value
appears in Column B - not all values in column A correspond to column b
values. So if I want to see how many females received a "5", I need to see
how many "female" in column A have a corresponding value of "5" in column B.
(not all females have a "5", values can be 1 through 5)