Sum Unique Values based on Criteria

[Starrbuckk]

Hi everyone,

I need help summing values that may repeat themselves and have a criteria that may repeat itself also.


[TABLE="width: 128"]
<tbody>[TR]
[TD="class: xl65, width: 64"]X[/TD]
[TD="class: xl65, width: 64"]Y[/TD]
[/TR]
[TR]
[TD="class: xl66"]a[/TD]
[TD="class: xl66"]10[/TD]
[/TR]
[TR]
[TD="class: xl67"]b[/TD]
[TD="class: xl67"]10[/TD]
[/TR]
[TR]
[TD="class: xl67"]c[/TD]
[TD="class: xl67"]20[/TD]
[/TR]
[TR]
[TD="class: xl68"]a[/TD]
[TD="class: xl68"]20[/TD]
[/TR]
[TR]
[TD="class: xl67"]b[/TD]
[TD="class: xl67"]30[/TD]
[/TR]
[TR]
[TD="class: xl66"]a[/TD]
[TD="class: xl66"]10[/TD]
[/TR]
[TR]
[TD="class: xl67"]c[/TD]
[TD="class: xl67"]40[/TD]
[/TR]
[TR]
[TD="class: xl67"]c[/TD]
[TD="class: xl67"]30[/TD]
[/TR]
[TR]
[TD="class: xl66"]d[/TD]
[TD="class: xl66"]20[/TD]
[/TR]
[TR]
[TD="class: xl68"]d[/TD]
[TD="class: xl68"]50[/TD]
[/TR]
[TR]
[TD="class: xl68"]e[/TD]
[TD="class: xl68"]30[/TD]
[/TR]
[TR]
[TD="class: xl66"]d[/TD]
[TD="class: xl66"]20[/TD]
[/TR]
[TR]
[TD="class: xl66"]e[/TD]
[TD="class: xl66"]10[/TD]
[/TR]
[TR]
[TD="class: xl66"]e[/TD]
[TD="class: xl66"]10[/TD]
[/TR]
</tbody>[/TABLE]


The idea is to sum only unique values based on the specified criteria. Example of desired result:

[TABLE="width: 163"]
<tbody>[TR]
[TD]Condition X[/TD]
[TD]Sum Value Y[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]90[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD="align: right"]70[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD="align: right"]40[/TD]
[/TR]
</tbody>[/TABLE]

For some reason i can't upload any attachment to the post, but i hope i've explained myself well enough.

 

[Starrbuckk]

I think it worked. Il try on the main file and check back later.
Thank you.

 

[Aladin Akyurek]

I think it worked. Il try on the main file and check back later.
Thank you.

You are welcome.

 

[Starrbuckk]

It does work, thank you. Now if i want to add another criteria, where should i put the other "IF"?

 

[Aladin Akyurek]

It does work, thank you. Now if i want to add another criteria, where should i put the other "IF"?

Like this:

=IF($D3="","",SUM(IF(FREQUENCY(IF($A$2:$A$15=D3,IF(...),MATCH($B$2:$B$15,$B$2:$B$15,0))),ROW($B$2:$B$15)-ROW($B$2)+1),$B$2:$B$15)))

 

[Starrbuckk]

Thanks so much. Saved me a lot of work.

Cheers

 

[Aladin Akyurek]

Thanks so much. Saved me a lot of work.

Cheers

You are welcome.