Answer the question
In order to leave comments, you need to log in
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)
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question