Check out Mr. Excel's site on array formula's

http://www.mrexcel.com/td0128.html

HTH

Die_Another_Day

Tarique wrote:
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.