Thread: Conditional Sum
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tarique Tarique is offline
external usenet poster
 
Posts: 7
Default Conditional Sum

I have take so much time for conditional sum and try different conditions but
in vain.
Please tell me the solution.
e.g:
Distributor Name Article NO. Sale
ABC Agency 701 15
ABC Agency 709 20
ABC Agency 1501 55
XYZ Traders 701 35

I want to sum the sales numbers by Article wise 701 & 1501 in same cell for
same distributor.
Please help me to solve this likly to cronic situation.