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.
COUNTIF function counts the number of times within the specified range of cells that perform the specified value as a criterion. Function syntax: =COUNTIF (range, criteria). 1  Range-the range of cells that you want to count the data.2  There has to be an ongoing area. 3  Criteria-a condition that must be met for cell counting. 4  In the case of numeric values-the condition can look like eg 100.unction syntax: =COUNTIF (range, criteria). 1  Range-the range of cells that you want to count the data. 2  There has to be an ongoing area.