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.
Next. I seem to be unable to use the SUM function in excel. Everytime i use the sum function, my result returns as 0. The correct result returns if i use the + function, ie, A3 = a1+a2.I have tried every possible cell format for both the range of numbers and for the formual cell. have also removed all formatting... show more I seem to be unable to use the SUM function in excel. Everytime i use the sum function, my result returns as 0. The correct result returns if i use the + function, ie, A3 = a1+a2.