View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lightstation67 lightstation67 is offline
external usenet poster
 
Posts: 1
Default SUMIF w/multiple conditions

Here's my current formula:

=SUMIF(A3:A50,"Consumer",J3:J50)/C55

This works fine to get an average sum for everything that reads Consumer,
but now I need to sum only the positive $ amounts in column "J3:J50". How and
where do I insert this extra condition?

Any help would be appreciate. Thanks