K
K
Ksenia Kuzmenko2021-06-17 15:07:17
Google Sheets
Ksenia Kuzmenko, 2021-06-17 15:07:17

Formula for Google Sheets?

Hello, help me choose a formula for the calculation.
I need to know from cell C ( Who created ) Natalia Zavodchikova + from cell D ( Order status ) Sent + from cell E ( Payment status ) Full payment + for what amount exactly by Zavodchikova Order amount from cell G ?
I tried using

=СУММЕСЛ(G2:G278;C2:C278;"Наталья Заводчикова", E2:E278;"Полная оплата", D2:D278;"Отправлен")

, but it doesn't come out. The formula by which I created the formula in cell J .
Help me please.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question