View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
stevec stevec is offline
external usenet poster
 
Posts: 177
Default sum only positive numbers for certain groups

Col A Col B Col C
apples -1
apples 3
apples 1 4
oranges -1
oranges -5
bananas 1 1

What formula in C will sum only positive numbers for each group of lables,
as indicated above, leaving other cells blank?

haven't figured out how to adjust sumproduct yet... thanks...