0

I have the following problem. There are order numbers in column A which are duplicated due to a different products in column B. What I need is to sum order values in column C only for unique order numbers when filter is applied.

Hereby some screenshots:

enter image description here

enter image description here

enter image description here

Could you guys please help me? Thanks in advance

Improve this question

1 Answer 1

Reset to default
1

Try using the following formula:

enter image description here

=SUM(DROP(UNIQUE(FILTER(HSTACK(A2:A14,C2:C14),MAP(D2:D14,LAMBDA(α,SUBTOTAL(103,α))))),,1))

When Manager Peter is selected:

enter image description here

When Country France is selected:

enter image description here

Improve this answer
2
  • You're a star! This works just perfect. Thank you very much for you help! Highly appreciated.
    – Zuzana Hošová
    Commented Jun 28 at 9:34
  • @ZuzanaHošová please ensure to accept the answer by ticking the checkmark beside it
    – Mayukh Bhattacharya
    Commented Jun 28 at 9:35

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .