Cannot Add Cells that Involve Formulas

  • Thread starter Thread starter mark1989
  • Start date Start date
M

mark1989

I have have a situation. I'm unable to add cells that are formulated.

Attached is a Microsoft Excel spreadsheet that will explain my problem
more in detail.

I'm attempting to create a spreadsheet that has a minor league baseball
schedule. All you do is enter the scores of both TEAM A and TEAM B in
the tan cells of columns "D" and "G".

In the "I" and "J" cells which are green, I have formulas such as
=IF(D8>G8,"1","0") and =IF(D8<G8,"1","0") that automatically insert a
"1" or "0" depending on if TEAM A Wins or loses. No problem here.

Where the problem occurs is in the red shaded cells in columns "I" and
"J" for the totals. I am unable to add the green shaded cells above
which are formulated.

What do I need to do?

Attachment filename: addition problem.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=396933
 
Mark1989

The problem seems to be your formula's are inserting a text value, not
a number.
Instead of
=IF(D8>G8,"1","0") and =IF(D8<G8,"1","0")

try
as =IF(D8>G8,1, 0) and =IF(D8<G8,1, 0)

Excel treats "1" as text the same is it would do to "Joe". removing
the quotes will force Excel to recogise it a as a number (that can be
summed)

If the suggested change causes disruption to your workbook, I suggest
you use the SUMIF and COUNTIF functions, as they will 'work' with text
to limited extent.
 
Kieran,

You are a real savior. Thanks a million. I appreciate your quick
response.

Mark
 
Back
Top