So... Excel has been kicking my *** for the last couple of hours, and I was hoping that someone might be able to help the silly me
A Picture to illustrate:
Excel kicking my ***.jpg
What I want to achive is for the Price to be summed under total price, but only when the ordernumber is the same. So in this case I want the sum of 75+100+150 in F19 because all the items are from the same order.
First i tried with the IF function, but didn't get there, and now with the SUMIF (SUM.HVIS in Danish, and ";" instead of ",").
They idea here was to make is sum when the ordernumber was the same (A16=A17), but it doesn't Work.
Anybody WHO can help?
Oh and it would be really cool if it only summed in the last of the rows of the same ordernumber (row 19 for order 1)
Thanks a bunch!