Thanks Biff, I'm not screaming as much now! However, what I'm trying to do is
add the results of the 2 formula within the same cell as the formulae.

"Biff" wrote:

Hi!

Change your fomulas from:

=IF(K3="","",IF(K3=M3,"1",""))

To:

=IF(K3="","",IF(K3=M3,1,""))

Enclosing numbers in quotes "1" converts the number to TEXT and can lead to
problems.

Why not just use a SUM function to sum the results of the 2 formulas?

=SUM(P3,P5)

=SUM(IF(K3="","",IF(K3=M3,"1",""))+IF(K5="","",IF( K5=M5,"1","")))

Using the syntax above will return an error if either of the condtionals
return "".

Biff

"Snap" wrote in message
...
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