Compare values in adjacent rows in one column, summing values in the same rows in a different column

[sunfoodandrew]

Hello, everyone. I have a spreadsheet with columns listing "Customer Name," "Extended Price," and "Date." Each customer purchased specific line items during a certain time period. The customer's name (unique for each customer) is "Customer Name," the total value of each item purchased is "Extended Price." For example, if "Customer A" purchased 3 of Item Z @ $5.00 each, then "$15.00" would be listed in the same row as "Customer A." The next row down, "Customer A" purchased 4 of Item Y @ $6.00 each, so the Extended Price is "$24.00."

I sorted the spreadsheet by "Customer Name," and I want to sum the values under "Extended Price" for each individual customer. Each customer purchased a different number of line items during this time period (Purchases represented by Customer A can be found in an array with 12 cells, Customer B needs 20 cells, etc.) Basically, I'm looking for one formula which will look in the column under "Customer Name," find the rows where "Customer Name" is the same, find the values of "Extended Price" in those same rows, and sum up "Extended Price" for each customer.

Any help will be greatly appreciated. Skype me if you think you can walk me though it, or reply to this thread.

- Andrew

 

[JackDanIce]

Pivot table sounds like the simplest/quickest way to do this. At work, no access to Skype

 

[ChrisM]

Sounds like a use of the standard "Subtotals" function, found on the Data menu. Will that not work?

 

[rconverse]

Hello, everyone. I have a spreadsheet with columns listing "Customer Name," "Extended Price," and "Date." Each customer purchased specific line items during a certain time period. The customer's name (unique for each customer) is "Customer Name," the total value of each item purchased is "Extended Price." For example, if "Customer A" purchased 3 of Item Z @ $5.00 each, then "$15.00" would be listed in the same row as "Customer A." The next row down, "Customer A" purchased 4 of Item Y @ $6.00 each, so the Extended Price is "$24.00."

I sorted the spreadsheet by "Customer Name," and I want to sum the values under "Extended Price" for each individual customer. Each customer purchased a different number of line items during this time period (Purchases represented by Customer A can be found in an array with 12 cells, Customer B needs 20 cells, etc.) Basically, I'm looking for one formula which will look in the column under "Customer Name," find the rows where "Customer Name" is the same, find the values of "Extended Price" in those same rows, and sum up "Extended Price" for each customer.

Any help will be greatly appreciated. Skype me if you think you can walk me though it, or reply to this thread.

- Andrew

Highlight your range and click on subtotals (on the data ribbon in 2007 and in the data menu in 2003, I believe). Select that you want to subtotal on customer name and sum extended price.

HTH,
Roger

Edit: Welcome to the board.