ADD WITH DUPLICATE CONDITIONALS

[Syndicate_Admin]

Hello.

If you can help me I have a table with several columns of all of them I want to add the values of a specific one, the point is that this contains duplicate records and I can not delete these are already used for other records, but I need each "SPLITER NOMENCLATURE" add only one record of the column "NAP - Copy".

I've tried this formula but it turns out that it only works for tables with two columns:

I leave the elace of excel workbook.

SUM IF - Google Sheets

[v-jianboli-msft · Accepted solution]

Hi @Syndicate_Admin ,

Please try:

Measure = SUMX(SUMMARIZE('Hoja11',Hoja11[NOMENCLATURA SPLITER],Hoja11[NAP - Copia]),[NAP - Copia])

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.