# Game score without game being played

1. ## Game score without game being played

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

2. ## Re: Game score without game being played

=if(count(homescore)=0,"Nothing",yourformulahere)

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

--

Dave Peterson

3. ## Re: Game score without game being played

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
<ec35720@netscapeXSPAM.com> wrote:

>=if(count(homescore)=0,"Nothing",yourformulahere)
>
>
>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

4. ## Re: Game score without game being played

I even laughed at your humour too, yes I know I said i want to put
NOTHING in the cell, but i just dont want the digit '0' in there.

sheila

On Sat, 14 May 2005 14:35:43 +1200, Sheila <sheilas_o_n_e@hotmail.com>
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
><ec35720@netscapeXSPAM.com> wrote:
>
>>=if(count(homescore)=0,"Nothing",yourformulahere)
>>
>>
>>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

5. ## Re: Game score without game being played

It's better to keep to the original thread instead of referring people who
are trying to help to look up your previous posts. Maybe you could explain
how the table is set up and why the result is zero, what you probably should
do is to redesign the table so zero without any games played is not possible

--
Regards,

Peo Sjoblom

"Sheila" <sheilas_o_n_e@hotmail.com> wrote in message
news:p8pa811u35dm11h5jek4ku3khr2pscee0n@4ax.com...
>I even laughed at your humour too, yes I know I said i want to put
> NOTHING in the cell, but i just dont want the digit '0' in there.
>
> sheila
>
>
>
>
> On Sat, 14 May 2005 14:35:43 +1200, Sheila <sheilas_o_n_e@hotmail.com>
> 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
>><ec35720@netscapeXSPAM.com> wrote:
>>
>>>=if(count(homescore)=0,"Nothing",yourformulahere)
>>>
>>>
>>>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

>

6. ## Re: Game score without game being played

Hi!

If you'd like to, you can send me your file and I'll take a look. I'm at:

xl "can" help at comcast period net

Get rid of the quoted stuff and change the obvious.

Biff

"Sheila" <sheilas_o_n_e@hotmail.com> wrote in message
news:p8pa811u35dm11h5jek4ku3khr2pscee0n@4ax.com...
>I even laughed at your humour too, yes I know I said i want to put
> NOTHING in the cell, but i just dont want the digit '0' in there.
>
> sheila
>
>
>
>
> On Sat, 14 May 2005 14:35:43 +1200, Sheila <sheilas_o_n_e@hotmail.com>
> 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
>><ec35720@netscapeXSPAM.com> wrote:
>>
>>>=if(count(homescore)=0,"Nothing",yourformulahere)
>>>
>>>
>>>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

>

7. ## Re: Game score without game being played

Tried that, but nobody looked at my follow up post >(*.*)<

Sheila

On Fri, 13 May 2005 19:49:02 -0700, "Peo Sjoblom" <terre08@mvps.org>
wrote:

>It's better to keep to the original thread instead of referring people who
>are trying to help to look up your previous posts. Maybe you could explain
>how the table is set up and why the result is zero, what you probably should
>do is to redesign the table so zero without any games played is not possible

8. ## Re: Game score without game being played

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
> <ec35720@netscapeXSPAM.com> wrote:
>
> >=if(count(homescore)=0,"Nothing",yourformulahere)
> >
> >
> >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

--

Dave Peterson

9. ## Re: Game score without game being played

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
<ec35720@netscapeXSPAM.com> 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
>> <ec35720@netscapeXSPAM.com> wrote:
>>
>> >=if(count(homescore)=0,"Nothing",yourformulahere)
>> >
>> >
>> >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

10. ## Re: Game score without game being played

>Nope, sorry Dave, that doesnt work either.

>Never mind, I will put up with it the way it is, thanks for trying.

Oh well!

Biff

"Biff" <biffinpitt@comcast.net> wrote in message
news:eHpni\$CWFHA.584@TK2MSFTNGP15.phx.gbl...
> Hi!
>
> If you'd like to, you can send me your file and I'll take a look. I'm at:
>
> xl "can" help at comcast period net
>
> Get rid of the quoted stuff and change the obvious.
>
> Biff
>
> "Sheila" <sheilas_o_n_e@hotmail.com> wrote in message
> news:p8pa811u35dm11h5jek4ku3khr2pscee0n@4ax.com...
>>I even laughed at your humour too, yes I know I said i want to put
>> NOTHING in the cell, but i just dont want the digit '0' in there.
>>
>> sheila
>>
>>
>>
>>
>> On Sat, 14 May 2005 14:35:43 +1200, Sheila <sheilas_o_n_e@hotmail.com>
>> 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
>>><ec35720@netscapeXSPAM.com> wrote:
>>>
>>>>=if(count(homescore)=0,"Nothing",yourformulahere)
>>>>
>>>>
>>>>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

>>

>
>

11. ## RE: Game score without game being played

Have you tried putting dashes in the cells with no scores yet?

"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
>

12. ## Re: Game score without game being played

If anybody is still following this thread....

Sheila sent me her file.

The problem involved having to test specific cells within two different
named ranges for "". Zero is a possible score so testing for for a sum of
zero wouldn't work.

Here's what I came up with:

Array entered:

For the Home Team score:

=IF(OFFSET(Rounds!\$A\$1,MATCH(1,(HomeTeam=B6)*(AwayTeam=\$C\$2),0),0)="","",SUMPRODUCT(--(HomeTeam=B6),--(AwayTeam=\$C\$2),AwayScore))

For the Away Team score:

=IF(OFFSET(Rounds!\$A\$1,MATCH(1,(HomeTeam=B6)*(AwayTeam=\$C\$2),0),4)="","",SUMPRODUCT(--(HomeTeam=B6),--(AwayTeam=\$C\$2),HomeScore))

The file would require a lot of these formulas and calc time will be slower.

Biff

"Sheila" <sheilas_o_n_e@hotmail.com> wrote in message
news:qhoc815kpuu5l4gunt873h92dpj3s6mf99@4ax.com...
> 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
> <ec35720@netscapeXSPAM.com> 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
>>> <ec35720@netscapeXSPAM.com> wrote:
>>>
>>> >=if(count(homescore)=0,"Nothing",yourformulahere)
>>> >
>>> >
>>> >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

>

13. ## Re: Game score without game being played

and it works just fine Biff, thanks very much

sheila

On Mon, 16 May 2005 14:47:57 -0400, "Biff" <biffinpitt@comcast.net>
wrote:

>If anybody is still following this thread....
>
>Sheila sent me her file.
>
>The problem involved having to test specific cells within two different
>named ranges for "". Zero is a possible score so testing for for a sum of
>zero wouldn't work.
>
>Here's what I came up with:
>
>Array entered:
>
>For the Home Team score:
>
>=IF(OFFSET(Rounds!\$A\$1,MATCH(1,(HomeTeam=B6)*(AwayTeam=\$C\$2),0),0)="","",SUMPRODUCT(--(HomeTeam=B6),--(AwayTeam=\$C\$2),AwayScore))
>
>For the Away Team score:
>
>=IF(OFFSET(Rounds!\$A\$1,MATCH(1,(HomeTeam=B6)*(AwayTeam=\$C\$2),0),4)="","",SUMPRODUCT(--(HomeTeam=B6),--(AwayTeam=\$C\$2),HomeScore))
>
>The file would require a lot of these formulas and calc time will be slower.
>
>Biff
>
>"Sheila" <sheilas_o_n_e@hotmail.com> wrote in message
>news:qhoc815kpuu5l4gunt873h92dpj3s6mf99@4ax.com...
>> 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
>> <ec35720@netscapeXSPAM.com> 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
>>>> <ec35720@netscapeXSPAM.com> wrote:
>>>>
>>>> >=if(count(homescore)=0,"Nothing",yourformulahere)
>>>> >
>>>> >
>>>> >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

>>

>

14. ## Re: Game score without game being played

Oh hey, I came up with something slightly more efficient. I used an INDEX
function in place of OFFSET.

Biff

"Sheila" <sheilas_o_n_e@walla.com(remove underscores)> wrote in message
news:37qi81t5ndaj56jkh5i12tc67p2305srvd@4ax.com...
> and it works just fine Biff, thanks very much
>
> sheila
>
>
> On Mon, 16 May 2005 14:47:57 -0400, "Biff" <biffinpitt@comcast.net>
> wrote:
>
>>If anybody is still following this thread....
>>
>>Sheila sent me her file.
>>
>>The problem involved having to test specific cells within two different
>>named ranges for "". Zero is a possible score so testing for for a sum of
>>zero wouldn't work.
>>
>>Here's what I came up with:
>>
>>Array entered:
>>
>>For the Home Team score:
>>
>>=IF(OFFSET(Rounds!\$A\$1,MATCH(1,(HomeTeam=B6)*(AwayTeam=\$C\$2),0),0)="","",SUMPRODUCT(--(HomeTeam=B6),--(AwayTeam=\$C\$2),AwayScore))
>>
>>For the Away Team score:
>>
>>=IF(OFFSET(Rounds!\$A\$1,MATCH(1,(HomeTeam=B6)*(AwayTeam=\$C\$2),0),4)="","",SUMPRODUCT(--(HomeTeam=B6),--(AwayTeam=\$C\$2),HomeScore))
>>
>>The file would require a lot of these formulas and calc time will be
>>slower.
>>
>>Biff
>>
>>"Sheila" <sheilas_o_n_e@hotmail.com> wrote in message
>>news:qhoc815kpuu5l4gunt873h92dpj3s6mf99@4ax.com...
>>> 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
>>> <ec35720@netscapeXSPAM.com> 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
>>>>> <ec35720@netscapeXSPAM.com> wrote:
>>>>>
>>>>> >=if(count(homescore)=0,"Nothing",yourformulahere)
>>>>> >
>>>>> >
>>>>> >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
>>>

>>

>

15. ## Re: Game score without game being played

Have done and put that in. Thanks, never thought about INDEX/MATCH
for this purpose.

Sheila

On Tue, 17 May 2005 00:22:16 -0400, "Biff" <biffinpitt@comcast.net>
wrote:

>Oh hey, I came up with something slightly more efficient. I used an INDEX
>function in place of OFFSET.
>
>
>Biff
>
>"Sheila" <sheilas_o_n_e@walla.com(remove underscores)> wrote in message
>news:37qi81t5ndaj56jkh5i12tc67p2305srvd@4ax.com...
>> and it works just fine Biff, thanks very much
>>
>> sheila
>>
>>
>> On Mon, 16 May 2005 14:47:57 -0400, "Biff" <biffinpitt@comcast.net>
>> wrote:
>>
>>>If anybody is still following this thread....
>>>
>>>Sheila sent me her file.
>>>
>>>The problem involved having to test specific cells within two different
>>>named ranges for "". Zero is a possible score so testing for for a sum of
>>>zero wouldn't work.
>>>
>>>Here's what I came up with:
>>>
>>>Array entered:
>>>
>>>For the Home Team score:
>>>
>>>=IF(OFFSET(Rounds!\$A\$1,MATCH(1,(HomeTeam=B6)*(AwayTeam=\$C\$2),0),0)="","",SUMPRODUCT(--(HomeTeam=B6),--(AwayTeam=\$C\$2),AwayScore))
>>>
>>>For the Away Team score:
>>>
>>>=IF(OFFSET(Rounds!\$A\$1,MATCH(1,(HomeTeam=B6)*(AwayTeam=\$C\$2),0),4)="","",SUMPRODUCT(--(HomeTeam=B6),--(AwayTeam=\$C\$2),HomeScore))
>>>
>>>The file would require a lot of these formulas and calc time will be
>>>slower.
>>>
>>>Biff
>>>
>>>"Sheila" <sheilas_o_n_e@hotmail.com> wrote in message
>>>news:qhoc815kpuu5l4gunt873h92dpj3s6mf99@4ax.com...
>>>> 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
>>>> <ec35720@netscapeXSPAM.com> 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
>>>>>> <ec35720@netscapeXSPAM.com> wrote:
>>>>>>
>>>>>> >=if(count(homescore)=0,"Nothing",yourformulahere)
>>>>>> >
>>>>>> >
>>>>>> >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
>>>>
>>>

>>

>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1