Count based on multiple criteria

[jyly]

Hi I am trying to find Table1[ID] that matches with Table7[Name], "Singer"

The only way to find this is if
Table1[ID] = Table7[IDs])
and Table7[IDs] = Table7[Name], "Singer"

but it keep showing error when I try to count it, how do I go around this?

 

[awoohaw]

I'm not sure exactly what values youre trying to count. A CountIF function would not normally have an ODD number of arguments.
I think the middle part of the second statement is not necessary.
Try this, maybe....

=COUNTIF(Table7[IDs],Table1[ID],Table7[Name],"Singer")

 

[jyly]

I'm not sure exactly what values youre trying to count. A CountIF function would not normally have an ODD number of arguments.
I think the middle part of the second statement is not necessary.
Try this, maybe....

=COUNTIF(Table7[IDs],Table1[ID],Table7[Name],"Singer")

hello, it is showing #SPILL! now unsure why

 

[awoohaw]

Mr excel has a tool called xl2bb (the link to the add in is below) that allows you to share miniworkbooks.
Please use that to post a sample of your data.

Thanks in advance.