sum formula needed

[kelly mort]

I have a table as below

Col A Col B Col C

a x 23
b y 10
c 12


In A I have only three items that keep repeating. "Say yes", "no", "not sure"

Then in B I have also only two items that keep repeating say male and female. Then in C I have the number of count for each entry.

Now the headache is how to uniquely count them :

1 . How many males said yes
2. How many females said yes
3. How many males said no
4. How many females said no
5. How many males said not sure
6. How many females said not sure

Thanks in advance
Kelly

 

[Sektor]

=SUMIFS(C:C,A:A,"no",B:B,"male")

 

[Aladin Akyurek]

It's hard to see the relation between the sample you show and the verbal description you provide. Care to comment?

 

[kelly mort]

It's hard to see the relation between the sample you show and the verbal description you provide. Care to comment?

Okay.

So let's link the a to yes b to no and c to not sure


Then x to male and y to female

Thanks
Kelly

 

[Aladin Akyurek]

Okay.

So let's link the a to yes b to no and c to not sure


Then x to male and y to female

Thanks
Kelly

So:

[TABLE="class: grid, width: 192"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]yes[/TD]
[TD="width: 64, bgcolor: transparent"]male[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]23[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]no[/TD]
[TD="bgcolor: transparent"]female[/TD]
[TD="bgcolor: transparent, align: right"]10[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]not sure[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]12[/TD]
[/TR]
</tbody>[/TABLE]

What are the expected results?

 

[Sektor]

@kelly mort
What about my answer?

 

[kelly mort]

@kelly mort
What about my answer?

Sorry for late reply.

I was adjusting it to my needs

Yes is worked great!!!!!
Thanks

 

[kelly mort]

So:

[TABLE="class: grid, width: 192"]
<tbody>[TR]
[TD="width: 64, bgcolor: transparent"]yes[/TD]
[TD="width: 64, bgcolor: transparent"]male[/TD]
[TD="width: 64, bgcolor: transparent, align: right"]23[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]no[/TD]
[TD="bgcolor: transparent"]female[/TD]
[TD="bgcolor: transparent, align: right"]10[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]not sure[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]12[/TD]
[/TR]
</tbody>[/TABLE]

What are the expected results?

I am counting the number of males who said yes from column c then males who said no etc

 

[Sektor]

You're welcome!

 

[Aladin Akyurek]

I am counting the number of males who said yes from column c then males who said no etc

Was this a results table or the data?

If the data, you should do a look up, not a conditional sum.