V
V
Viktor Familyevich2020-09-04 08:32:20
Google Sheets
Viktor Familyevich, 2020-09-04 08:32:20

How to calculate the amount with a condition?

Hello. There are three columns:
B. Manager's name
F. Order status
H. Order amount
There is a table on a separate sheet that counts the order amounts for each manager:

=SUMIFS(
INDIRECT("'Sheet'!$H$1:H");
INDIRECT("'Sheet'!$F$1:F");"ordered";
INDIRECT("'Sheet'!$B$1:B" );A4)

How can I make sure that orders only from a certain amount are considered? For example, from 1000 rubles?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
N
Noir, 2020-09-04
@Wintego

=SUMIFS(
INDIRECT("'Sheet'!$H$1:H");
INDIRECT("'Sheet'!$F$1:F");"ordered";
INDIRECT("'Sheet'!$B$1:B" );A4;
INDIRECT("'Sheet'!$H$1:H");">1000")

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question