And I want to say no, you donât need a lot of money, particularly in a place like the Philippines. The Philippines is not a third world country, letâs get that out of the way. Itâs a second world country.
To sum cells based on multiple criteria (for example, blue and green), use the following SUMIFS function (first argument is the range to sum). General note: in a similar way, you can use the AVERAGEIF and AVERAGEIFS function to average cells based on one or multiple criteria.
Since SUMIF() can be applied only to single row or column, your evaluation must be carried out in 2 steps. First use SUMIF() on rows and also concatenate the condition values for each summation in an adjacent cell. This concatenated string will serve as a key in next step. Next apply SUMIF() to the column that contains row sums, using the key from previous step as the condition. share|improve this answer.