"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)

Or try :

=SUMPRODUCT(--(A1:A10&B1:B10="female5"))

Regards
Bosco