What formula to use?

Question

Google Sheets

How to calculate the revenue for each client with one formula, not counting the revenue for each order separately? As I understand it, you need to use arrayformula, but I don’t understand exactly how to use it.

Answer 1

Like this, for example:

=ЕСЛИОШИБКА(СУММПРОИЗВ(filter($B$2:$B$7;$A$2:$A$7=A12);filter($C$2:$C$7;$A$2:$A$7=A12)))

Demo table

Answer 2

=sumif(D1:D;A;A;A12)