Sum a column if there is a duplicate in another and remove blank rows

I am still so new to all of this and trying so hard to learn to make my life a little easier.

I have exported my sales from MYOB and now I need to sum the total if the invoice number is a duplicate and remove the blank rows, but keep the rest of the data.

I know this is possible, I hope this is possible, is this possible?

If Column H is a duplicate number, then i need to sum column R and remove the other rows and blank rows. Leaving one row per invoice number, with a true reflection of the invoice value.

Thank you if you are able to assist me.

Originally Posted by JodiBlack

1. to sum the total if the invoice number is a duplicate
2. and remove the blank rows, but keep the rest of the data

but

Originally Posted by JodiBlack

1a. If Column H is a duplicate number, then i need to sum column R
2a. and remove the other rows and blank rows

So,

for points: 1 and 1a:
... almost okay, only there is no "R" column (in the xls file) with values to sum - is it about the "Q" column ?

for points: 2 and 2a:
... remove blank and other/remaining rows or just blank ?

Which rows are the "other" ones, how should it finally be ?

Thank you.

Points 1 and 1a - yes, it is column Q with the total value that needs to be sum up. Sorry for the confusion.

Points 2 and 2a - the "other" rows which I was referring to was the ones with duplicate invoice number.

I have added a sheet to show what I am after the data to look like.

But if there is a different Item number, they need to stay on separate lines (sorry, forgot about that variable in my original post).

Try

Please Login or Register  to view this content.