The American Optometric Association suggests that children should have their first regular eye exam at six months of age. Another vision exam should take place when a child is around two or three years of age when their vision undergoes its most rapid development and vision correction is most effective.
The ISNUMBER function is a quick, easy way to check if a cell contains a number. Our example used the IF function to illustrate how ISNUMBER can be used. If you haven't used IF in a formula before, you can read our lesson on the IF function here.
To sum if cells contain specific text in another cell, you can use the SUMIF function with a wildcard and concatenation. In the example shown, cell G6 contains this formula: =SUMIF(C5:C11,*&F6&*,D5:D11) This formula sums the amounts in column D when a value in column C contains the text in cell F6.