Forum Discussion
Excel function needed
On the "reg invoices" tab. If the value in column D is the same then add the value in column I.
The values in column D are orders numbers. I need the total value associated with each order number.
I hope this makes more sense.
THANK YOU!
It does make more sense...and I've created a solution. It may or may not be the best solution. It also depends on one relatively new function...UNIQUE...which requires the most recent versions of Excel.
Basically I created a new sheet in your workbook, called "Dashboard," and entered two formulas. The first is this:
=UNIQUE('reg invoices'!D1:D1926)
That function is in Cell C3 of the Dashboard; this function generates a complete list of all the unique invoice numbers, whether they appear just once or appear 100s of times
Then, in the adjacent column, I entered:
=SUMIF('reg invoices'!$D$1:$D$1926,Dashboard!C3,'reg invoices'!$I$1:$I$1926)
and copied it down to all the rows that had an invoice number in them. This gets the total associated with each invoice number.
I see that Riny_van_Eekelen has just given you another solution, equally functional (and, importantly, not relying on the new function UNIQUE. The Pivot Table solution is a good one as well. One of the great aspects of Excel--which you're experiencing here--is that there are often two or more ways, quite distinctive, to accomplish the same result.