Group and Sum in Excel

[gearhead03]

I have a spreadsheet that on each row has a load number and rate columns. (among others)
I would like to have the program sum the amounts in the rate column based on the load number cells being the same.

For example if three of the rows have 9595 in the load number column it would sum those amounts.

Any number of rows can have the same number in the load number column.

Thanks for your help

Mark A. Kale

 

[SkipVought]

Hi,

Check out Data > Subotoal; made to order!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[SkipVought]

Ahhhh, my dyslexia.

Data > Subtotal

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[gearhead03]

Thanks Skip! I'll give it a try and check back in!

Mark A. Kale

 

[gearhead03]

Worked Great Thank You!

Mark A. Kale

 

[buitenhek]

If it worked for you give Skip a STAR! It helps his ratings as well as strokes his extremely small ego.

Regards
Peter Buitenhek
ProfitDeveloper.com

 

[SkipVought]

[sub]Very, very [gray]very small[/gray][/sub] [red]EGO[/red]!!!

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]