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

 

[kelly mort]

Was this a results table or the data?

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

I am counting from the data table to a different sheet.


Sektors formula did what I wanted to do.

For now I will be glad to know another way about it.

Thanks
Kelly

 

[Aladin Akyurek]

I am counting from the data table to a different sheet.


Sektors formula did what I wanted to do.

For now I will be glad to know another way about it.

Thanks
Kelly

Still not clear. What is your data if it's not what you have posted? Mind you, counting and summing are not the same thing.

 

[kelly mort]

Yes you are correct!

I mean summing not counting.

I want to sum them up.

Regards
Kelly

 

[Aladin Akyurek]

Yes you are correct!

I mean summing not counting.

I want to sum them up.

Regards
Kelly

In this exhibit...

yes	male	23
no	female	10
not sure		12

<colgroup><col><col span="2"></colgroup><tbody>
</tbody>

does column C house a formula? If it does, care to post it?

 

[kelly mort]

Yes c houses a formula but I am not with my pc now so I will post later when I get home. Thanks