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.
Sum if equal to either x or y. If you need to sum numbers based on other cells being equal to either one value or another (either x or y), you can use the SUMIF function. In the example show, we are summing all sales from either the West OR North region. Where region is a named range for C5:C30 and amount is a named range for E5:E30.