I am trying to write a excel formula for the following data: I have a
cell for each month that can contain a postive or negative $ value. I
want the "total cell" to only add the cell for that month if the value
is greater than or equal to $10.00. So for example; month 1 is
-$14.00, month 2 is $4.00, month 3 is $16.00, month 4 is $10.00, and
month 5 is $34.00. The answer should be $60.00 (month 1 = 0, month 2 =
0, month 3 = 16, month 4 = 10, and month 5 = 34; for a total of 60).

Please help!!!


--
rusty2005
------------------------------------------------------------------------
rusty2005's Profile: http://www.excelforum.com/member.php...o&userid=36901
View this thread: http://www.excelforum.com/showthread...hreadid=566152