Stop counting the blanks in formula

Hi All,

In the attached file (tournament file) I have all my formula's pulling information from the Master Schedule. It all seems to work, but one little issue. The Tie Column keeps counting blank ("") as ties instead of ignoring them. It is only on this column and I am sure it is because of the formula I am using. I have tried a couple different variations, even adding a new if statement, but it doesn't seem to work.

In the data, it should only show Edgewood and Vipers as a tie. It should view the blanks (games with no scores) as games unplayed. Example: Fishers Tigers Red should only show as 1 game played.

The formula I used works well for tallying wins and losses and not counting blanks, it seems to be the ties it struggles with.

Here is the formula I am using now below.

=(SUMPRODUCT(('Master Schedule'!$A$3:$A$109='Teams Entered'!$B2)*('Master Schedule'!$B$3:$B$109='Master Schedule'!$E$3:$E$109)))+(SUMPRODUCT(('Master Schedule'!$D$3:$D$109='Teams Entered'!$B2)*('Master Schedule'!$E$3:$E$109='Master Schedule'!$B$3:$B$109))))

Hello,

You are correct FDibbins. That is supposed to be looking to see if the scores are tie/draw.

As to your formula, that was spot on. I knew I was missing something simple. I kept trying to do If and countif and such. Sometimes after staring at things to long your mind just stops processing properly. Thank you again.

Hi Daddylonglegs,

This formula also works and it would simplify my formula even further. I can even apply this to some of the other columns. When I built them, I was doing 1 piece at a time. Thanks for this tip. I always like to have the simplest formula possible if I can get there.

Again, this forum has been incredibly helpful for both my play and work projects.