I have a formula (thanks to others) that provides a 1 or a blank dependant on
data input (the result of a match - tie=1).

What I need now is a formula that will add the 1's to give a total number of
ties for any particularteam. i'm trying to create a league table.

The formula for each match is
=IF(K3="","",IF(K3=M3,"1",""))

I now want to apply this to another match eg =IF(K5="","",IF(K5=M5,"1",""))
and add the two results to give an answer of 2. My logic came up with
=SUM(IF(K3="","",IF(K3=M3,"1",""))+IF(K5="","",IF( K5=M5,"1","")))
but the computer tells me in its own way that I'm an idiot!

Can anyone help stop me from screaming!!

Thanks