Excel Formula

[rusty2005]

I am trying to write a excel formula for the following data: I have
cell for each month that can contain a postive or negative $ value.
want the "total cell" to only add the cell for that month if the valu
is greater than or equal to $10.00. So for example; month 1 i
-$14.00, month 2 is $4.00, month 3 is $16.00, month 4 is $10.00, an
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!!

 

[VBA Noob]

The attached looks only at the values.

=SUMPRODUCT(--(B1:B5>=10)*(B1:B5))

More on sumproduct on the attached link

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

VBA Noo

 

[Guest]

=SUMIF(A1:A5,">=10",A1:A5)

will this do the trick?

 

[Ragdyer]

Say the months are in Column A, and the values are in Column B, from B1 to
B12.

Try this:

=SUMIF(B1:B12,">=10")

 

[rusty2005]

Thanks a million!