- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2007 January
- sum based on the names in the list

Subject: | sum based on the names in the list |

Posted by: | navin (navin.naraya…@gmail.com) |

Date: | 11 Jan 2007 |

Hi,

I have a sheet, in which, col A contains name of suppliers (sorted

alphabatically) and col B contains qtys which was delivered by the

supplier.

Now i have get the sum of the qty based on the supplier.

Supplier Name Sum of Delivered Qty

AAAAA 56

AAAAA 30

AAAAA 17

AAAAA 8

AAAAA 8

AAAAA 1

AAAAA 10

BBBB 20

BBBB 40

BBBB 55

BBBB 65

BBBB 8

BBBB 1

BBBB 10

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

deliverd qty.

Hope my problem is clear.

Thanks,

Navin

- Re: sum based on the names in the list posted by Don Guillett on Thu, 11 Jan 2007
- Re: sum based on the names in the list posted by Roger Govier on Thu, 11 Jan 2007
- Re: sum based on the names in the list posted by Earl Kiosterud on Thu, 11 Jan 2007