Nope, sorry Dave, that doesnt work either.
Never mind, I will put up with it the way it is, thanks for trying.
Sheila
On Sat, 14 May 2005 07:23:33 -0500, Dave Peterson
wrote:
Ah, you only want to check if that team in $c$2 has been used:
=IF(SUMPRODUCT(--(hometeam=$C$2),--(ISNUMBER(homescore)))=0,"",
SUMPRODUCT(--(hometeam=$C$2),--(awayteam=B5),homescore))
(all one cell)
Sheila wrote:
Sorry Dave, no that doesnt work.
Please see previous post titled "Summarising scores"
TIA
Sheila
On Fri, 13 May 2005 18:05:28 -0500, Dave Peterson
wrote:
=if(count(homescore)=0,"Nothing",yourformulaher e)
Sheila wrote:
I am using Sumproduct
=SUMPRODUCT(--(HomeTeam=$C$2),--(AwayTeam=B5), HomeScore)
to put team scores on a team sheet, but still get a score of 0 - 0
when the game hasnt been played and no score is entered onto the
'schedule' sheet. This is not ideal. How can i have NOTHING go into
the cells when the game has not been played. These scores come from a
'schedule' sheet with all games for the year listed.
any help?
sheila
TIA
|