Thread: Need help with grouped counts

I am working on some spreadsheets at work, and need help with "grouped
sums," although that probaby is not the correct name for it.

Example:

In A1:A500 you have city names. Most, but not all, of the cities appear
more than once, some 40-50 times.

In B1:B500 you have dollar amounts received from each city.

What I need is:

In Column C, each city in Column A, just ONE time.

In Column D, the total amount of dollars received from the city in
column C.

I am usually pretty good with formulas and can dabble in VBA, but I
cant hack this one for some reason. Can anybody help?

Thanks,
Ron M.

try the SUMIF formula

excel help gives a good example of how to use it.

Simon

"bstevens@rock.com" wrote:

> I am working on some spreadsheets at work, and need help with "grouped
> sums," although that probaby is not the correct name for it.
>
> Example:
>
> In A1:A500 you have city names. Most, but not all, of the cities appear
> more than once, some 40-50 times.
>
> In B1:B500 you have dollar amounts received from each city.
>
> What I need is:
>
> In Column C, each city in Column A, just ONE time.
>
> In Column D, the total amount of dollars received from the city in
> column C.
>
> I am usually pretty good with formulas and can dabble in VBA, but I
> cant hack this one for some reason. Can anybody help?
>
> Thanks,
> Ron M.
>
>