See subtotals per customer

[jonas-martens]

Hi,

i'm new with the use of arrays and can't figure them out very well...

I have an input table with multiple customers and some values linked to each customer.
My prefered output is a list of all customers who meet two conditions, if these conditions are OK then show the total of all values per customer.

Example attached.
Thanks in advance

[jindon]

Your condition
3) Do not add customers in output if Value_2 = 0

Do not match to your result.

[jonas-martens]

Hi Jindon,

Sorry for the (small) fault.

If Value_1 = 0 then don't add in output.

[jindon]

Then this should do.

Please Login or Register  to view this content.