Excel Formula
 

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

Excel Formula
 

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 Noob


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

Excel Formula
 

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

will this do the trick?

"rusty2005" wrote:


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

Excel Formula
 

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

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"rusty2005" wrote
in message ...

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

Excel Formula
 

Thanks a million!


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