"J. Sperry" wrote:

Somehow, a rogue dash got inserted in the equations. Where it says "20-0",
change it to "200". By the way, you also need some dollar signs to anchor
the cell references. Heck, I just redo them to avoid confusion.

Cell B2 totals the wins:
=Sum(if(Sheet1!A$1:A$200=A2,if(Sheet1!E$1:E$200="W ",1,0)))+Sum(if(Sheet1!D$1:D$200=A2,if(Sheet1!F$1: F$200="W",1,0)))
Cell C2 totals the losses:
=Sum(if(Sheet1!A$1:A$200=A2,if(Sheet1!E$1:E$200="L ",1,0)))+Sum(if(Sheet1!D$1:D$200=A2,if(Sheet1!F$1: F$200="L",1,0)))


" wrote:

The first part worked great...Thanks!

This part I'm having a bit of a problem with....

I deleted all the extra spaces, headings, etc.. off the tab
"LeagueSchedule" (where the team scores are, thinking that was causing
th problem. I created a new sheet and added the formulas, just as you
described below...nothing. It gave me a #REF in the blocks. :( Any
thoughts?

Then a table (in a new worksheet) to tally the results
Cell A2 has team name
Cell B2 has wins:
=Sum(if(Sheet1!A1:A200=A2,if(Sheet1!E1:E200="W",1, 0)))+Sum(if(Sheet1!D1:D20-0=A2,if(Sheet1!F1:F200="W",1,0)))
Cell C2 has losses:
=Sum(if(Sheet1!A1:A200=A2,if(Sheet1!E1:E200="L",1, 0)))+Sum(if(Sheet1!D1:D20-0=A2,if(Sheet1!F1:F200="L",1,0)))


Ok I figured out what the problem was...LOL I didn't use the ctrl+shft+enter
thing. :) But all is good with the formula working...

How can I use the formulas in multiple columns and still tally the wins and
losses on the scoreboard???

http://www.4shared.com/file/30266118...FBL_07-08.html

There is a copy of the sheet I'm working on.