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.
How To Use the SUM function: 1  Select the cell where you want the result to appear (ex: A4). 2  Type =SUM. 3  Enter a parenthesis. 4  Select the range of cells you want add together OR type in the cell references.5  Enter another parenthesis.ow To Use AUTOSUM : You can use AUTOSUM to automatically enter the SUM function and add a list of numbers. When you click on the button, Excel will guess the range of cells you want to add. You are able to change that range. 1  Select the cell in which you want to result to appear.