I have a problem with getting a total Sum of numbers (URGENT)

[mark1989]

I'd really appreciate if someone could help me here.

I am using Microsoft Excel 2002 on a Microsoft Office XP system. I a
trying to develop a minor league baseball schedule, but am having som
problems.

I have attached a copy of my spreadsheet to give everyone some idea o
what I'm doing here.

I have where the fans list the "RUNS, HITS & ERRORS) of both teams an
for each game of the series. I then have it set up in the TOTA
WON/LOST column where if the T-Bones RUNS are more than the SALTDOG
runs, a "1" appears in the WON column. If the SALTDOGS have a highe
number in the RUN column, then a "1" is populated in the LOST column.
That isn't the problem.

In box L11, I have the formula =IF(D11>H11,"1","0"). This is the sam
for the other yellow highlighted boxes.

In the red highlighted boxes, I'm trying to add all the WON/LOS
numbers for a total and cannot do it because of the formulas suc
as=IF(D11>H11,"1","0"). What formula if any can I use to get the tota
sum?

Thanks in advance for anyone's help

Attachment filename: excel tip 1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=39571

 

[Bob Phillips]

Mark,

Don't use text numbers, that is, change

=IF(D11>H11,"1","0")

to

=IF(D11>H11,1,0).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)