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 AVERAGEIF function was added in Excel 2007 to make it easier to find the average value in a range of data that meet certain criteria. One handy use for the function is that you can get it to ignore zero values in your data that can throw off the average.he AVERAGEIF function was added in Excel 2007 to make it easier to find the average value in a range of data that meet certain criteria. One handy use for the function is that you can get it to ignore zero values in your data that can throw off the average.