Selecting cells in a row for a formula

T

tomo

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I am trying to run a formula to count the number of times a certain result appears ie win or loss. The problem i have is that i only want to use certain cells from the row to run the formula according to whether a game is home or away. In between cell ids do i use , or : or +.

I have included an example of the type of formula that i am trying to run:
=SUM(couNTIF(C16,E16,U11,G16,I16,K16,M16,Q16,S16,{"win","loss"}))
 
B

Bob Greenblatt

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I am trying to run a formula to count the number of times a certain result
appears ie win or loss. The problem i have is that i only want to use certain
cells from the row to run the formula according to whether a game is home or
away. In between cell ids do i use , or : or +.

I have included an example of the type of formula that i am trying to run:
=SUM(couNTIF(C16,E16,U11,G16,I16,K16,M16,Q16,S16,{"win","loss"}))
I think you are better off using an array formula. Describe in some more
detail what your sheet looks like and I'll offer a solution.
 
T

tomo

Thanks for the reply Bob.

Basically i am recording results of a season according to home and away criteria.

The information is recorded according to the round number. ie Column B - Rnd 1, Column C - Rnd 2 etc

For each game information is recorded on whether the game was played at home or away, the score for and against and the result ie Row 3 Home/away, Row 4 - Score for, Row 5 - Score against, Row 6 - result (this is calculated using an IF formula)

This is repeated for the number of teams in my league on the same sheet.

I am trying to use a formula that will calculate a team's home/away record as they play through the season ie played 4 at home but only won 2.
I attempted to use a formula to work out the number of wins for home in one cell (=COUNTIF(C6,"=win")+COUNTIF(E6,"=win")+COUNTIF(G6,"=win")+COUNTIF(I6,"=win")+COUNTIF(J6,"=win")+COUNTIF(M6,"=win")+COUNTIF(O6,"=win")+COUNTIF(Q6,"=win")+COUNTIF(T6,"=win")and the total home games played in the next using the formula in the previous post but cant seem to get past this wall.

Any help greatly apprciated
 
B

Bob Greenblatt

Thanks for the reply Bob.

Basically i am recording results of a season according to home and away
criteria.

The information is recorded according to the round number. ie Column B - Rnd
1, Column C - Rnd 2 etc

For each game information is recorded on whether the game was played at home
or away, the score for and against and the result ie Row 3 Home/away, Row 4 -
Score for, Row 5 - Score against, Row 6 - result (this is calculated using an
IF formula)

This is repeated for the number of teams in my league on the same sheet.

I am trying to use a formula that will calculate a team's home/away record as
they play through the season ie played 4 at home but only won 2.
I attempted to use a formula to work out the number of wins for home in one
cell
(=COUNTIF(C6,"=win")+COUNTIF(E6,"=win")+COUNTIF(G6,"=win")+COUNTIF(I6,"=win")+
COUNTIF(J6,"=win")+COUNTIF(M6,"=win")+COUNTIF(O6,"=win")+COUNTIF(Q6,"=win")+CO
UNTIF(T6,"=win")and the total home games played in the next using the formula
in the previous post but cant seem to get past this wall.

Any help greatly apprciated
I'm still having trouble visualizing this. It doesn't look like anything
confidential, so if you'll send me a copy of the sheet, and explain again
what you want to count, I'll show you by adding the formulas.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top