Countifs, index, match help wanted

[DawitX]

So I have a massive sheet with data entries I want to summarize in another sheet. I have enclosed a smaller version of the data sheet. Basically A2:R2 in the sheet called 2014 (see enclosed file) is column names and they don't always end up in the same order because of not so logical reasons. I want to have in the summary-sheet for each column the amount of entries that are not "-". The entries I want to count can be numbers or greather than/lesser than a number (e.g. ">30" ), but if there is no entry it will always say "-" instead of a blank cell.
I'm trying to solve this problem using the following formula I found for the English column name, but with no success.

=COUNTIFS(INDEX('2014'!$A$3:$R$32;0;MATCH("English";'2014'!$A$2:$R$2;0));"<>-")

Not sure what I'm doing wrong

Another thing I want to be able to do is to count the number of siblings. Every person that has the same ID-number are siblings and I'm trying to count the number of duplicates in the 2014-sheet to get the number of siblings. Is there a formula to count duplicates?

[ChemistB]

Your formula works on your example sheet (result is 2). Look for extra characters/spaces in your workbook.

Do you want to know how many siblings there are for a specific ID? or all ID's. So if 2 people share an id, is that 1 sibling or 2? What about 1 person with an ID, is that 0 or 1?

[DawitX]

Thank you for your quick reply, ChemistB.

I don't get any result but the "NAME?"-error, do you see any problems with spaces that I have missed?

I want siblings for all ID's, so if 2 people share ID the answer would be 2 and if it's a unique ID it would return 0.

[ChemistB]

#Name means there's something (text) in the formula that excel doesn't recognize. Make sure your Quote marks are real quotes and not "Smart quotes", Go to Formula Tab and click on "Error Checking" and then "Show Calculation Steps" Maybe that will help.

[ChemistB]

For Siblings,
Using an intermediate column, let's say S. In S3 copied down, assuming the ID is in Column A
=IF(COUNTIF($A$3:$A3, A3)>1,0, IF(COUNTIF($A:$A,A3)=1,0, COUNTIF($A:$A, A3)))
Then just SUM(S:S)