heck yea ill take it !!!!!
this is for a complete season each person will be in it each week so if
there are any changes you might think i need to make ket me know!!!and thanks
for the help i am sooo happy:)
--
bob



"Biff" wrote:

Well, it doesn't do EXACTLY what you want....

Instead of returning a "Win" or "Loss" I use conditional formatting to
highlight the wins or losses.

My file is for the NFL. It's already setup for the upcoming season. Each
week the people in the pool make their picks then each week is summarized
and a running total is calculated along with a winning %. I also have it
weighted because each week the number of people that participate changes.
That way, if someone only picks 1 week and goes 16-0 with a winning
percentage of 1.000 they will not win over someone who picks every week and
has a lower winning percentage.

Biff

"Biff" wrote in message
...
Hi!

I have a file that does exactly what you want. Want a copy?

Biff

"bob" wrote in message
...
hello
First i dont even know is this is possible orif i am using the right
program
but...i would like to set excell for a football pool where each players
pick
is matched against the outcome of that game and will enter the value win
or
loss i used the formula =IF(AND(D2=B2,D2<C2),"win","loss") but its not
error proof also i would like a function add up all the win and losses to
get
a win loss record for that week i.e. 11-5 if thats possible you are a god
and
i am the happiest person alive
--
bob