1 Set goals. 2  Just like with adult weight loss, the weight loss goals in children should be attainable, allowing for normal growth. 3  The goals should initially be small, so that the child doesn't become discouraged or overwhelmed. 4  A five to 10 pound weight loss is a reasonable first goal -- about 1 to 4 pounds per month. The goals should initially be small, so that the child doesn't become discouraged or overwhelmed. 2  A five to 10 pound weight loss is a reasonable first goal -- about 1 to 4 pounds per month. 3  Food diary.
The SUMIFS function extends the usefulness of the SUMIF function by allowing you to specify from 2 to 127 criteria rather than just one as in SUMIF. Normally, SUMIFS works with rows of data called records.
Since SUMIF() can be applied only to single row or column, your evaluation must be carried out in 2 steps. First use SUMIF() on rows and also concatenate the condition values for each summation in an adjacent cell. This concatenated string will serve as a key in next step. Next apply SUMIF() to the column that contains row sums, using the key from previous step as the condition. share|improve this answer.