|Subject:||sum based on the names in the list|
|Posted by:||navin (navin.naraya…@gmail.com)|
|Date:||11 Jan 2007|
I have a sheet, in which, col A contains name of suppliers (sorted
alphabatically) and col B contains qtys which was delivered by the
Now i have get the sum of the qty based on the supplier.
Supplier Name Sum of Delivered Qty
is there any formula, which will give me the sum, supplier wise. I know
this can be achieved by doing pivot, but i do not want to do a Pivot
because after the sum, total by supplier will be divided by each
Hope my problem is clear.