counting text occurrance in multiple column

[enialy]

I'm using =COUNTIF(a1:a40,"word") to count the text occurance for a single column, but now I want to know what do i use to know the total number a word appeared that matches the other word from another column. I know it's confusing, i'm totally confuse now. I can't even explain it right.

it's like this:
Picture1.png


i need to get the total of every white female and every white male.

Thank you in advance!!

[Fotis1991]

Hi

In C11, try this.

=SUMPRODUCT((A1:A6="white")*(C1:C6="male"))

Same for the others.

[enialy]

Thanks!! what took me forever took you seconds to do! life is a bit unfair

[Cutter]

An alternative:

=COUNTIFS($C$1:$C$6,B$10,$A$1:$A$6,$A11)

[Fotis1991]

You are welcome!

....life is a bit unfair

Life is always unfair for all of us, but not at the same time!! Today maybe is for you, Tomorrow maybe will be for me.

Of course, Cutter's formula(as you are in Excel 2010) works a great for you too!

Pls, mark your Thread, as SOLVED!

[enialy]

An alternative:

=COUNTIFS($C$1:$C$6,B$10,$A$1:$A$6,$A11)

Thank you!!