# Conditional summing

**URL:** <https://community.silverfin.com/t/conditional-summing/1101>\
**Category:** Templates\
**Tags:** math, control\_flow, if, for\_loop\
**Created:** [August 8, 2018, 12:54pm UTC](https://community.silverfin.com/t/conditional-summing/1101 "2018-08-08T12:54:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bart\_Verhaeghe](https://avatars.discourse-cdn.com/v4/letter/b/c4cdca/32.png) [@Bart\_Verhaeghe](https://community.silverfin.com/u/Bart_Verhaeghe)\
**Post date:** [August 8, 2018, 12:54pm UTC](https://community.silverfin.com/t/conditional-summing/1101/1 "2018-08-08T12:54:15Z")

</div>

Hi,

In case one of my colleagues might need to make a conditional sum:

```
    Doel: de voorwaardelijke som maken van een array gebaseerd op een andere array

{% comment %}A = 25, B = 7, C = 8, D = 3{% endcomment %}

{% assign str_persons = 'A|B|A|C|B|D' %}
{% assign str_amounts = '10|5|15|8|2|3' %}

{% assign arr_persons = str_persons | split:'|' %}
{% assign arr_amounts = str_amounts | split:'|' %}

{% assign arr_persons_unique = arr_persons | uniq %}
{% assign int_persons_unique_counter = 0 %}

{% for person_unique in arr_persons_unique %}

  {% assign int_ConditionalSum_person_unique = 0 %}
  {% assign int_persons_counter = 0 %}

  {% for person in arr_persons %}

    {% if person == arr_persons_unique[int_persons_unique_counter] %}
      {% assign int_ConditionalSum_person_unique = int_ConditionalSum_person_unique | plus:arr_amounts[int_persons_counter] %}
    {% endif %}
    {% assign int_persons_counter = int_persons_counter | plus:1 %}
  
  {% endfor %}
    
    {% assign str_ConditionalSum_person_unique = str_ConditionalSum_person_unique | append:int_ConditionalSum_person_unique | append:'|' %}
    
    {% assign int_persons_unique_counter = int_persons_unique_counter | plus:1 %}

{% endfor %}

{% assign str_ConditionalSum_person_unique = str_ConditionalSum_person_unique | slice:0,str_ConditionalSum_person_unique.size-1 %}

{% assign arr_ConditionalSum_person_unique = str_ConditionalSum_person_unique | split:'|' %}

unique persons: {{arr_persons_unique | join:'|'}}

total amounts per person: {{arr_ConditionalSum_person_unique | join:'|'}}
```