Skipping blank cells with IF function

Hi,

I am creating a league table which will have Wins, Loss, Draw and will be sorted by Points.

Heres my problem:
The table is complete, I have a another sheet for a list of fixtures. But the problem is, I am using a IF Function for all the Wins, Loss, Draws. At the moment all the fixtures are empty (no scores inserted yet) So the IF function for the Draw's is picking up that those are draws so in my table its showing Played 12 games, Drawn 12 games. How can I make it ignore the blank cells?

Thanks

Using your sample file - perhaps modify the approach to:

Please Login or Register  to view this content.

In terms of sorting - you would be much better served using one table to calculate on an unsorted basis (as you have now) and use a 2nd table to retrieve the values from the unsorted table in order.

In terms of the formulae used - for info. on SUMPRODUCT see the link in my sig. to Bob Philips' white paper, for info. on SUMIF see XL Help.

You would use formulae - but first we would need to understand the means by which you would differentiate those on equal points (and the order of precedence).

Obviously Points is the first determining factor - if Points are level what comes next ? Wins / GD ? And if still level after that ?

Apologies for delay - I've not been online much this afternoon.

Attached would be one possible approach - columns M:AA can be hidden (via Grouping)

The attached has some RANDBETWEEN functions generate random scores which is why with each calc the results table changes - hopefully this will be sufficient for you.

Column X is essentially used to generate a number based on your precedence rules such that the greater the number the higher the rank - each number will be unique.
Column Y ranks based on X
Column Z is determining the row number of each position (1 to 7) - this is to reduce no. of repetitive calcs being performend in Cols C:K