Thread: Sum of a range if the value in cells are 0
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default 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


Reply With QuoteReply With Quote