I need to add up all the values in one column that correspond to values in another column

**mjd5507** · 10-02-2023, 11:46 AM

Hello, I have a large spreadsheet that shows order numbers in one column and markdowns in another, the problem is the raw data added the order number to each individual markdown, I need to get a table that has the sum of the markdowns for each order number. Any help is appreciated.

Excel Help.JPG

**MrShorty** · 10-02-2023, 11:53 AM

A pivot table seems like the obvious first thing to try: https://www.excel-easy.com/data-****...ot-tables.html

**FDibbins** · 10-03-2023, 12:42 AM

mjd5507 those look like Home Depot order numbers? Allison Park perhaps?

I need to add up all the values in one column that correspond to values in another column

LinkBack

Thread Tools

Rate This Thread

Display

I need to add up all the values in one column that correspond to values in another column

Re: I need to add up all the values in one column that correspond to values in another col

Re: I need to add up all the values in one column that correspond to values in another col

Thread Information

Users Browsing this Thread

Similar Threads

How do I list all values that correspond with duplicate values in another column

Finding 5 largest values in a column and then returning the rows that correspond

How to add the last N values of column B that correspond to a particular value in Column A

[SOLVED] Finding values from one sheet that correspond to the right column/row of another sheet

[SOLVED] Rule to find cells in column A that correspond to multiple values in column B

If text values in range, look up numerical values that correspond and sum in one cell

Outputting values in column B that correspond to certain values in column A

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions