Dave Wrote:
hbb2699

If I am not misunderstanding you, I believe that you have created a
circular
reference. If you data is in D2 to D13, I would suggest using the
formula
you stated in cells E2 to E13 and then sum that column.

Hope this helps

Dave


[/color]

I am sorry, I think I messed up on the cell letters.

The cells I am putting the IF formula in are F2 through F13. The data
is in cells D2 through D13.

It did work however, to take out the " around the numbers. I didn't
realize that using a " made it text. Thank you both very much for your
help!!! :)


--
hbb2699
------------------------------------------------------------------------
hbb2699's Profile: http://www.excelforum.com/member.php...o&userid=35224
View this thread: http://www.excelforum.com/showthread...hreadid=549994