The following example uses one argument -- a reference to cells A1:A5. 1  Enter the sample data on your worksheet. 2  In cell A7, enter a AVERAGEA formula, to average the numbers in column A: =AVERAGEA(A1:A5) 3  Press the Enter key, to complete the formula.  The result will be 16.38, the average of the cells that contain data.
Tijeras, New Mexico. Tijeras is a village in Bernalillo County, New Mexico, United States. The population was 541 at the 2010 census. It is part of the Albuquerque Metropolitan Statistical Area.
Cibeles is surrounded by the grand white wedding cake-like Communications Palace from 1917, Linares Palace from 1900 and now the site of the Casa de America cultural center, the 1777 Buenavista Palace and now Spain's Army Headquarters, and the Bank of Spain, completed in 1891.