R
Roger Govier
Hi
Try
="You : Computer = "&
COUNTIF(E:E,"You Won!*")&
" : "&COUNTIF(E:E,"You Lost*")
Try
="You : Computer = "&
COUNTIF(E:E,"You Won!*")&
" : "&COUNTIF(E:E,"You Lost*")
S
StargateFan
I'm sorry; this is probably really simple but I can't seem to find
anything in the archives. I don't know what I'm dealing with, I
guess.
I have 2 columns, C and D, where a user inputs his/her scores on any
given day. Then in column E, the formula below says if you won or
not:
=IF(AND(ISNUMBER($C2),ISNUMBER($D2)),IF($C2=D2,"Tied!",IF($C2>$D2,"YOU
WON!","You lost
(")),"")
In G1, I'd like to create a tally of the wins and losses so that the
user can now his/her overall standing. i.e., if there are 16 losses
and about 55 wins or so.
I'm thinking something like this might work, though if there's
something better, I'm open to suggestions from much more experienced
users <g>:
You : Computer = 55 : 16
Thanks.D
anything in the archives. I don't know what I'm dealing with, I
guess.
I have 2 columns, C and D, where a user inputs his/her scores on any
given day. Then in column E, the formula below says if you won or
not:
=IF(AND(ISNUMBER($C2),ISNUMBER($D2)),IF($C2=D2,"Tied!",IF($C2>$D2,"YOU
WON!","You lost
(")),"")In G1, I'd like to create a tally of the wins and losses so that the
user can now his/her overall standing. i.e., if there are 16 losses
and about 55 wins or so.
I'm thinking something like this might work, though if there's
something better, I'm open to suggestions from much more experienced
users <g>:
You : Computer = 55 : 16
Thanks.
D