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.
The SUMIF function syntax has the following arguments: 1  range Required. The range of cells that you want evaluated by criteria. 2  criteria Required. The criteria in the form of a number, expression, a cell reference, text, or a function that defines which cells will be added. 3  sum_range Optional.