Disregard empty cells

[nickcee]

The attached sheet shows a league table for a simple competition run over 20 or so weeks for 12 teams and with a quirky scoring system. The problem I have is recording the total number of tied games accumulated by the teams (tied games being worth one league point). Having laid out the fixtures for the entire season the formula at cell H4:M4 effectively counts the empty cells in columns C&D for future games as being tied by virtue of null value equaling null value or whatever. Yes I could write or copy and paste the fixtures but having come this far..... What can I add/create to solve the empty cell problem? TIA

[shg]

In H4,

= SUMPRODUCT(($B$9:$B$17=H$1) * ($C$9:$C$17=$D$9:$D$17) * ($C$9:$C$17 <> ""))
+ SUMPRODUCT(($E$9:$E$17=H$1) * ($D$9:$D$17=$C$9:$C$17) * ($D$9:$D$17 <> ""))

[Phuocam]

Or try:

=SUMPRODUCT((($B$9:$B$17=H$1)+($E$9:$E$17=H$1))*($C$9:$C$17=$D$9:$D$17)*($C$9:$C$17<>""))

[nickcee]

That did the trick! I'm obliged to you. Many thanks

[shg]

Don't know which you used, but Phuocam's is better.

[nickcee]

Used both with success so only difference is the number of characters. Either way it stopped me scratching my head for a few hours and I'm grateful. Thanks again