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.

Need help with grouped counts
 

try the SUMIF formula

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

Simon

" 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.