Sum of a range if the value in cells are 0
 

I need to get a sum of a range that included negative numbers...I dont
want the negative numbers in the sum. How do I add up just the
positive 0 numbers.


--
hcamelion
------------------------------------------------------------------------
hcamelion's Profile: http://www.excelforum.com/member.php...o&userid=36736
View this thread: http://www.excelforum.com/showthread...hreadid=564597

Sum of a range if the value in cells are 0
 

=SUMPRODUCT(--(A1:A50)*(A1:A5))

or

=SUM((A1:A50)*(A1:A5))

enter the latter with Ctrl+Shift+Enter (array formula)

HTH

"hcamelion" wrote:


I need to get a sum of a range that included negative numbers...I dont
want the negative numbers in the sum. How do I add up just the
positive 0 numbers.


--
hcamelion
------------------------------------------------------------------------
hcamelion's Profile: http://www.excelforum.com/member.php...o&userid=36736
View this thread: http://www.excelforum.com/showthread...hreadid=564597

Sum of a range if the value in cells are 0
 

=SUMIF(A:A,"0")

Vaya con Dios,
Chuck, CABGx3




"hcamelion" wrote:


I need to get a sum of a range that included negative numbers...I dont
want the negative numbers in the sum. How do I add up just the
positive 0 numbers.


--
hcamelion
------------------------------------------------------------------------
hcamelion's Profile: http://www.excelforum.com/member.php...o&userid=36736
View this thread: http://www.excelforum.com/showthread...hreadid=564597

Sum of a range if the value in cells are 0
 

Thanks they all worked great. I actually had done one of the ones
mentioned =SUM((A1:A50)*(A1:A5)) but i didnt know about entering
Ctrl+Shift+Enter to designate it an array.


--
hcamelion
------------------------------------------------------------------------
hcamelion's Profile: http://www.excelforum.com/member.php...o&userid=36736
View this thread: http://www.excelforum.com/showthread...hreadid=564597