"Snap" wrote in message
...
Thanks Lance, but this formula counts blank cells eg if K3 and M3 are
blank
(match not yet played, say) then a result of 1 is given.

"LanceB" wrote:

=IF(K3=M3,1,0)+IF(K5=M5,1,0)

=AND(K3=M3,K3<"",K5<"")+AND(K5=M5,K5<"",M5<"")

If you want the answer to be blank until all the match results are entered,
then you could use:
=IF(OR(K3="",K5="",M3="",M5=""),"",(K3=M3)+(K5=M5) )
--
David Biddulph