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.
To get the average of a set of numbers, excluding or ignoring zero values, use the AVERAGEIF function. In the example shown, the formula in E6 is: =AVERAGEIF(B6:D6,<>0) How this formula works. AVERAGEIF performs an average based on criteria you supply. In this example, the criteria supplied is <>0, which means not equal to zero. Like AVERAGE , AVERAGEIF automatically ignores blank cells and text.