If you want to include logical values and text representations of numbers in a reference as part of the calculation, use the VARPA function. The equation for VAR.P is: where x is the sample mean AVERAGE (number1,number2,…) and n is the sample size. More @Wikipedia
Hover over any link to get a description of the article. Please note that search keywords are sometimes hidden within the full article and don't appear in the description or title.