Unique Sumifs - 2 x Data sets, with references but repeated across multiple lines.

[seash]

Hi All,

Hopefully someone can help,

I have a summary page with details of schemes, it has 2 differing reference numbers, some lines have both, others one or the other, also end dates for schemes etc.

I also have a separate tab with invoice details, again utilising the same series of references, similarly some with both, one or the other.

I want to be able to uniquely 'sumif' the invoice value (totals) into my summary page.

Current attempts are bringing back the values duplicated due to the reference issues described above.

[mcmahobt]

Upload a sample workbook that shows how your data is setup.

[mikeTRON]

You need to develop a way of identifying unique records then grab ONLY those.

[seash]

Sample book attached, summary page 'packages', invoices tab.

Need to sumif the invoices into the packages tab

[mcmahobt]

What are we supposed to be summing? It looks like you already have summed your invoices on the Packages sheet in your example.

[seash]

I have already tried a few things, but as the references are repeated on the front page they are being duplicated in the sum. Does that make sense

[mcmahobt]

It makes sense in theory, but when I look at the data all logic seems to fail. The data just doesn't seem to be organized coherently. What is the extra columns A and D used for on the Invoices sheet?

[seash]

Hi there,

A - I have run a count of the occurences of that same reference in the summary 'packages' page
B - Existing in the sheet - Reference number
C - Existing in the sheet - Secondary Reference number
D - My added column - I have tried to force the sheet to give me just one reference, for me to sumif from.

The data is poor, I have to agree.