M
Mike
Hello all,
Using Excel XP.
I have a formula in column Q that gives an overall running win and lost
record based on either a W (for a win) or an L (for a lost) in column P.
An example in cell P4 is a W so the formula would give a result of 1-0
P5 is an L so the formula would give a
result of 1-1
P6 is an L so the formula would give a
result of 1-2
=COUNTIF($P$4
4,"W")&"-"& COUNTIF($P$44,"L")
=COUNTIF($P$45,"W")&"-"& COUNTIF($P$45,"L")
=COUNTIF($P$46,"W")&"-"& COUNTIF($P$46,"L")
How could write the above formula based on a ceertain location in column B.
I would like to find out the home win and lost record if the location in
column B is equal to Boston. I tried adding another countif but it still
gave me the overall record. Any help would be appreciated.
Mike
Using Excel XP.
I have a formula in column Q that gives an overall running win and lost
record based on either a W (for a win) or an L (for a lost) in column P.
An example in cell P4 is a W so the formula would give a result of 1-0
P5 is an L so the formula would give a
result of 1-1
P6 is an L so the formula would give a
result of 1-2
=COUNTIF($P$4
4,"W")&"-"& COUNTIF($P$44,"L")=COUNTIF($P$4
5,"W")&"-"& COUNTIF($P$45,"L")=COUNTIF($P$4
6,"W")&"-"& COUNTIF($P$46,"L")How could write the above formula based on a ceertain location in column B.
I would like to find out the home win and lost record if the location in
column B is equal to Boston. I tried adding another countif but it still
gave me the overall record. Any help would be appreciated.
Mike