Formular Help

[Sanderch]

Hi All,

I'm not great with excel and am trying to complete a premier league table. (yes sorry another football spread sheet)

This would be straight forward but I have included the cup games in the results table and added a column (AB) to state Prem (premier league game) or cup (any cup game)

The problem is on the Games playes part of the spreadsheet where i count the results. I'm currentley using

=SUMPRODUCT(--(Results!$G$6:$G$91="Man Utd"),--ISNUMBER(Results!$D$6:$D$91))

this as you probley know counts any times Man Utd is in G but the result is populated. (this works) but i would like to somehow include where the AB column is "prem" or is not "cup" to exclude any cup games (or vice versa include only prem games)

So where Results!$AB$6:$AB$91 ="Prem" I just can't get this to work.

I can send spread sheet if needed.

hope this makes sence

SanderCH

 

[barry houdini]

Hello Sanderch, try like this

=SUMPRODUCT(--(Results!$G$6:$G$91="Man Utd"),--ISNUMBER(Results!$D$6:$D$91),--(Results!$AB$6:$AB$91="Prem"))

 

[Sanderch]

Thanks Barry easy when you know how..