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.
MAX IF Formula. Although Excel has a SUMIF function and a COUNTIF function, there is no MAXIF function. To create your own MAXIF, you can combine the MAX and IF functions in an array formula. In this example, we'll find the highest value for a specific product in a sales list with multiple products.irst, enter the MAX and IF functions, and their opening brackets: =MAX(IF(. Next, select the product names in the sales list, and press the F4 key, to lock the reference. =MAX(IF($G$2:$G$17. Type an equal sign, and click on the cell with the product name criteria.